Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?
- 1 Answers
- 3752 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a full join sql?
what are different types of keys in sql?
If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please
What is Primary Key?
What are the disadvantages of not performing database normalization?
What is the difference between explicit and implicit cursors in oracle?
What are the types of keys?
How do you optimize a query?
How long it takes to learn pl sql?
Explain the types of joins in sql?
Show the cursor attributes of pl/sql.
How to access the current value and next value from a sequence?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
