Show code of a cursor for loop.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,


Does sql full backup truncate logs?

0 Answers  


What is nvl?

0 Answers  


What is crud stand for?

0 Answers  


What are pl sql data types?

0 Answers  






1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,


What do you mean by “trigger” in sql?

0 Answers  


how to get the third quarter of employee details from emp?

2 Answers   CompuTech,


How do rank () and dense_rank () differ?

0 Answers  


Why query optimization is needed?

0 Answers  


cursor types? explain with example programs?

1 Answers   HP,


What are pl/sql packages?

0 Answers  


Categories