Select Listagg(rownum*3, ', ') within group (order by

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

Question Posted / bhavya

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does sql server run?

529

What are the operators used in select statements?

572

What are the different dcl commands in sql?

559

What are data types in pl sql?

559

What is the difference between Union and Union all. Which is faster.

844

Explain about various levels of constraint.

519

Difference between table function and pipelined function?

583

Explain constraints in sql?

569

Does sql require a server?

525

Why is %isopen always false for an implicit cursor?

568

How many types of functions are there in sql?

501

what is normalization? : Sql dba

559

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595

What is the difference between sql and t sql?

533

What is a memo field?

525