Write a pl/sql script to display the following series of numbers: 99,96,93&helli

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

Question Posted / ratnakar mishra

1 Answers
4931 Views
I also Faced
E-Mail Answers

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 a materialized view? : Sql dba

0 Answers

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers BT,

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers TCS,

Is sql a programming?

0 Answers

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers HCL,

what is the difference between nested subquery and correlated subquery?

0 Answers

Name the different types of indexes in sql and define them.

0 Answers

Does a primary key have to be a number?

0 Answers

What is crud stand for?

0 Answers

What is difference between stored function and application function?

0 Answers

What are the steps for performance tuning.

0 Answers

Can sql developer connect to db2?

0 Answers

For more SQL PLSQL Interview Questions Click Here