What is the order of defining local variables and sub procedures/functions?
No Answer is Posted For this Question
Be the First to Post Answer
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
20. Using a set operator, display the client number of all clients who have never placed an order.
please explain.. DB architecture ...
How to add another datafile to a tablespace?
What are the predefined tablespaces in a database?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
How to filter out duplications in the returning rows using oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to drop an index in oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is the quickest way to fetch the data from a table?