what is the difference between rownum pseudo column and row_number() function? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
Explain exception handling in pl/sql?
Is progress software supports to ( pl/sql )?
What happens when a trigger is associated to a view?
How to move files from one directory to another in pl sql?
How to prepare for oracle pl sql certification?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
What is an index and types of indexes. How many number of indexes can be used per table ?
12 Answers Accenture, BirlaSoft, Cognizant, CTS, Symphony,
What are the subsets of sql?
How to start the command-line sql*plus?
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,
Mention what is the function that is used to transfer a pl/sql table log to a database table?