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 ?    6 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is meant by truncate in sql?

1 Answers  

Is json a nosql?

1 Answers  

what is sql optimization

1 Answers   Fidelity,

Can you rollback after commit?

1 Answers  

What is nosql db?

1 Answers  

What are stored procedures used for?

1 Answers  

How do I remove sql developer from windows 10?

1 Answers  

What are the various restrictions imposed on view in terms of dml?

1 Answers  

How many row comparison operators are used while working with a subquery?

1 Answers  

What is the primary key?

1 Answers  

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

What is the use of procedures?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories