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 |
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What information is needed to connect sql*plus an oracle server?
What is a loop in sql?
How do you retrieve the second highest salary from a table?
List the ways to get the count of records in a table?
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
What is meaning of <> in sql?
What is ON DELETE CASCADE?
How do you pronounce sql?
when is the use of update_statistics command? : Sql dba
why not null constraint showing its constraint type as 'c'
What is optimistic concurrency control? : Transact sql
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)