Why use subqueries instead of joins?
Does sql backup shrink transaction log?
What is 19 null in sql?
Where is sql database stored?
Why is normalization important?
Is primary key always clustered index?
1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....
how to retrieve the top 2 salaried persons from a database?
How well can multiple sessions access the same data simultaneously ?
How to write html code in pl sql?
What are the basic techniques of indexing?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
Explain the PL/SQL compilation process.