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 |
What is the non-clustered index in sql?
Where is pl sql used?
what is the difference between trigger and constraint?
wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh
What will you get by the cursor attribute sql%rowcount?
what is error ora-03113: end-of-file on communication channel?
What is a unique key and primary key and foreign key?
What is sql prepared statement?
use of IN/ANY/ALL
What is left inner join in sql?
What is difference between hql and sql?
What is oracle sql developer?
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)