A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answers were Sorted based on User's Feedback
Answer / intelligent
select * from emp where rownum>101 and rownum<121
| Is This Answer Correct ? | 2 Yes | 18 No |
What are the possible values for the boolean data field?
what is the stuff function and how does it differ from the replace function? : Sql dba
real time applications of nullif?
What is a REF CURSOR? Compare strong and week ref cursor types.
What is schema in sql?
what is cursor. write example of it. What are the attributes of cursor.
What are pl sql procedures?
Define the select into statement.
pl/sql testing means what ...... explain process how to find pl/sql bugs
what is try_catch block in procedure
Can dml statements be used in pl/sql?
Define a temp table?
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)