1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

Question Posted / ratnakar mishra


Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?..

Answer / bhavya

Select
Listagg(rownum*3, ', ') within group (order by rownum desc)
From dual
Connect by level<=100/3;

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

when a procedure /package is getting invalidated?

4 Answers   TCS,

what is log shipping? : Sql dba

0 Answers  

why use cursors?

5 Answers   Oracle,

Is sql a dbms?

0 Answers  




how to get a list of columns in an existing table? : Sql dba

0 Answers  

What is diff between bulk collect and forall

3 Answers   Metric Stream,

What is information schema in sql?

0 Answers  

Are subqueries faster than joins?

0 Answers  

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

How can you create Cursor with parametres ?

3 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories