| Subject | Date Asked | Expert |
|
| Sql loader nullif duplicate column data | 11/18/2008 | Suchitra Joshi |
Q: I want to null a column (DOC_XREF2) if the data is equal to another column (DOC_XREF1). I can't get ...
A: I have never tried this. But you can try removing the brackets around the condition. i.e use the ...
|
| whats my next step | 11/18/2008 | Suchitra Joshi |
Q: I'm a b.tech in computer Science and Eng, and took my OCP certification in Oracle 9i in 2004. ...
A: I think Oracle experience is the most important factor in your career. The certifications will not ...
|
| PS security | 11/17/2008 | Peter Choi |
Q: If the user has two roles for example with access to the same page and if i remove one of the roles, ...
A: Assuming the two roles with access to the same page had the same access (e.g. read-write), then with ...
|
| Why do LOB segments shrink when MOVEd ? | 11/13/2008 | Elliot Mak |
Q: I am wondering why when I execute SQL like : ALTER TABLE MYTABLE MOVE LOB(LOBCOLUMN) STORE AS ...
A: I am not too clear of your question. So I am going to answer your question differently and hope it ...
|
| oracle 8i | 11/13/2008 | Peter Choi |
Q: how to import .dmp files from oracle 8i
A: Here's a great reference about import (it can apply to 8i, 9i and 10g- so long as you're not using ...
|
| Why do LOB segments shrink when MOVEd ? | 11/12/2008 | Elliot Mak |
Q: I am wondering why when I execute SQL like : ALTER TABLE MYTABLE MOVE LOB(LOBCOLUMN) STORE AS ...
A: Good day Serge, That's a very interesting question. First of all, there are two types of LOB ...
|
| Select and Group BY | 11/8/2008 | Peter Choi |
Q: I've got this select which works just fine: SELECT a.partNum, MIN(a.Quote) as "Price" FROM ...
A: I'll use a simple example from my earlier one. If I wanted to count how many members are in each ...
|
| Select and Group BY | 11/8/2008 | Peter Choi |
Q: I've got this select which works just fine: SELECT a.partNum, MIN(a.Quote) as "Price" FROM ...
A: If I extended my example query so show me the lowest student id in the query: SELECT ...
|
| Select and Group BY | 11/8/2008 | Peter Choi |
Q: I've got this select which works just fine: SELECT a.partNum, MIN(a.Quote) as "Price" FROM ...
A: Your select statement can include selecting from both tables. What you need to look at is the ...
|
| Oracle index internals | 11/7/2008 | Elliot Mak |
Q: When index is created on a column of a table, what exactly is stored in the index. If every value of ...
A: Let's talk about b-tree index. In a b-tree index, it contains two types of blocks. They are branch ...
|
| Oracle index internals | 11/7/2008 | Peter Choi |
Q: When index is created on a column of a table, what exactly is stored in the index. If every value of ...
A: In an Oracle table, each row in every table is assigned a unique ROW ID identifier (You can't see ...
|
| Oracle Select * | 11/6/2008 | Elliot Mak |
Q: Is there any advantage on performance of putting table column headings in select statement instead ...
A: There are many ways to look into your question. Let's start from the database, then the network, ...
|
| Trace of an oracle stored procedure | 10/31/2008 | Peter Choi |
Q: How can I get the statistics of an oracle stored procedure, like cpu,timing statistics etc. Can we ...
A: In Oracle 10gR2, the SQL TRACE utility is available to generate some statistics: * Parse, ...
|
| related to reports | 10/31/2008 | Suchitra Joshi |
Q: Can I run the oracle report from local??? Means I want to call a report from my oracle forms. If ...
A: I have not used Oracle forms and reports for last 5 yrs. But I am sure there is some run_report ...
|
| Oracle | 10/31/2008 | Edson |
Q: I wanted to update some 400 records. 'RKTBG-EA-120001' To 'RKTBG-EA-120400' has to be changed as ...
A: If all prefixes are RKTBGEA-EA- then update tab set col = 'R-KT-BG-EA-' || substr(col,12) if ...
|
| Case statements and subqueries | 10/30/2008 | Elliot Mak |
Q: I have a column with either percentages, grams or an error message stored in it. I.e. EnteredValue ...
A: This is how I understand your question. On the table, you have two columns. using the same data ...
|
| About NVL | 10/29/2008 | Peter Choi |
Q: I write a query with huge data with NVL function in C#.Net for Oracle 11g then i see that the result ...
A: It's possible for that query, you might need a function-based index: i.e. an index on that column ...
|
| Oracle database | 10/29/2008 | Elliot Mak |
Q: Sir, I created a database manually in Oracle 9i with CREATE DATABASE command. it has been ...
A: Good day Jasvinder Before I provide you the respective command, I just want to make sure that all ...
|
| Total vacation days per month | 10/29/2008 | Edson |
Q: Edson, I want to calculate the number of vacation days per month for each employee based on the ...
A: It is not "end Dec", what is listed bellow is a case case when () then end alias The jan, feb ...
|
| Normalization | 10/26/2008 | Peter Choi |
Q: what is 1st-NF(normal form)
A: Here's a great reference as to what the 1st normal form is: ...
|
| Total vacation days per month | 10/26/2008 | Edson |
Q: Edson, I want to calculate the number of vacation days per month for each employee based on the ...
A: I made a query that I think can help you. But this query has to be a lot tested, so I suggest you ...
|
| PS Security | 10/23/2008 | Peter Choi |
Q: I am getting an error message "Authorization Error -- Contact your Security Administrator " when i ...
A: If you have copied or cloned your user/role/privilege from an existing user/role/privilege and then ...
|
| logging on to oracle to unpoplulate db | 10/22/2008 | Peter Choi |
Q: I am a new hire for my company and running thru a set of instructions i have received from them. In ...
A: Without knowing what your script is doing, here are some things to look at or note: 1. It would ...
|
| Case statements and subqueries | 10/21/2008 | Edson |
Q: I have a column with either percentages, grams or an error message stored in it. I.e. EnteredValue ...
A: I donīt know if I understood your question, but I did a little sql that I tnink can help you: ...
|
| Case statements and subqueries | 10/21/2008 | Elliot Mak |
Q: I have a column with either percentages, grams or an error message stored in it. I.e. EnteredValue ...
A: Personally, I try to avoid using subquery in a column. The reason is that for each row returns from ...
|
| sudo columns | 10/20/2008 | Peter Choi |
Q: could u tell me where oracle store sudo colums values i know this is not an actual column but when ...
A: The pseudo column values are not stored anywhere in Oracle. Rather, it is derived. For example, when ...
|
| sudo columns | 10/20/2008 | Peter Choi |
Q: could u tell me where oracle store sudo colums values i know this is not an actual column but when ...
A: Dual table is like your scratch-pad. you can try different queries & functions using Dual. For. e.g. ...
|
| scn | 10/20/2008 | Peter Choi |
Q: I want to understand what is a SCN in oracle what is use and important. please explain me brefily . ...
A: The system change number (SCN) is an ever-increasing value that uniquely identifies a committed ...
|
| Basic Parent child Relationship | 10/17/2008 | Suchitra Joshi |
Q: Table 'Relation' has 2 fields, Parent and Child. Records Parent Child p1 c1 p2 ...
A: Following is the query to get all child/subchild - select child from relation start with ...
|
| Future Advice | 10/13/2008 | Suchitra Joshi |
Q: I am MSC(IT),OCP and preparing SCSA.I have around 1.6 years of experience as developer DBA. ...
A: If you have Oracle DBA experience, it is a great plus in your career. You try to get jobs in the ...
|
| Position Management | 10/12/2008 | Vikash Pattnaik |
Q: Sir Currently an employee is in a position. The position is reporting to itself as it highest ...
A: Why don't you let the highest position report to itself within position management? What do you ...
|
| Clear Screen through PL SQL | 10/11/2008 | Edson |
Q: ! Please help me to find out the solution for PL SQL questions : 1. How to Print the boolean ...
A: One possible solution is the folowing: declare A boolean; B Varchar2(10); begin a := ...
|
| DBA Questions | 10/10/2008 | Peter Choi |
Q: I have some question can u give me the ansers. 1. If i lost all controlfile and i have no backup ...
A: Here's a great reference site for technical interview questions and answers: ...
|
| Oracle 9i and 10g client on same pcs | 10/9/2008 | Peter Choi |
Q: I have a property application running on 9i and CadcorpSIS GIS on 10g. I would like to use the same ...
A: You should be able to just install and use the Oracle 10g client on your workstation and configure ...
|
| sql query | 10/8/2008 | Suchitra Joshi |
Q: i have been trying some queries on a tutor site and i came across the following query in which i am ...
A: Here is the query - select distinct maker ,case (select nvl(count(distinct pc.model),0) ...
|
| Position Management | 10/7/2008 | Vikash Pattnaik |
Q: Sir Currently an employee is in a position. The position is reporting to itself as it highest ...
A: Good to hear from you. From your mail I would assume the you have a full-position management system. ...
|
| Table creation in oracle | 10/7/2008 | Suchitra Joshi |
Q: Good Evening Mam, Please Tell me How create a sql query for such this table..... ...
A: Following is the create statement - create table marks_detail ( sem_code number(1), subject_code ...
|
| SYS password | 10/7/2008 | Peter Choi |
Q: If i forgot my sys password then how can i login as sys user if i am not using password file . ...
A: Reference: http://forums.oracle.com/forums/thread.jspa?threadID=375629 Log on to the machine where ...
|
| oracle license | 10/6/2008 | Vikash Pattnaik |
Q: do license really very important , I want buy CD and install it in one computer which will be the ...
A: Though this subject does not directly come under my area of expertise, I understand that every ...
|
| oracle license | 10/6/2008 | Peter Choi |
Q: do license really very important , I want buy CD and install it in one computer which will be the ...
A: Oracle has two different licensing plans that allows companies and organizations to choose what ...
|
