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
- 5010 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 |
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
How many clustered indexes can be created on a table?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How do you exit in sql?
What is fmtonly in sql?
what is data manipulation language? : Sql dba
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
What is data definition language?
How to test for null values?
How do I add a primary key to a table?
what is d diff between grant,commit,rollback n savepoint
What is the difference between a primary key and a unique 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)
