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

Is sql developer case sensitive?

0 Answers  


How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,


How many types of normalization are there?

0 Answers  


Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  


What is forward declaration in pl sql?

0 Answers  






What are the types of optimization?

0 Answers  


Is delete faster than truncate?

0 Answers  


What are sql constraints?

0 Answers  


Does inner join return duplicate rows?

0 Answers  


what is isam? : Sql dba

0 Answers  


How to pipe multiline string to isql?

0 Answers  


Write a query to find the names of users that begin with "um" in sql?

0 Answers  


Categories