Interested to Buy Any Domain ? << Click Here >> for more details...
Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?
- 1 Answers
- 5014 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 ? | 6 Yes | 1 No |
What are the different dcl commands in sql?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is the plv (pl/vision) package offers?
what is a database lock ? : Sql dba
What is trigger in sql? Explain
What are different methods to trace the pl/sql code?
how to install mysql? : Sql dba
what is hash join
What is a sql instance vs database?
suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary
What is procedure in pl sql?
What is sql key?
-
Oracle (3253) - 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)
