Sign Up Login


  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

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

What is the syntax and use of the coalesce function?

0 Answers  

What is a string data type in sql?

0 Answers  

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

What is a transaction?

5 Answers  




Can we use joins in subquery?

0 Answers  

How to convert ms-excel file to oracle table?

2 Answers  

What is a memo field?

0 Answers  

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

What is a mutating table

5 Answers   TCS, Tech Mahindra,

What is the use of stored procedures?

0 Answers  

what is heap table? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories