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

Post New Answer

More SQL PLSQL Interview Questions

Explain exception handling in pl/sql?

0 Answers  


Is progress software supports to ( pl/sql )?

0 Answers  


What happens when a trigger is associated to a view?

0 Answers  


How to move files from one directory to another in pl sql?

0 Answers  


How to prepare for oracle pl sql certification?

0 Answers  






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????

3 Answers   Infosys,


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?

0 Answers  


How to start the command-line sql*plus?

0 Answers  


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?

0 Answers  


Categories