How exception is different from error?
No Answer is Posted For this Question
Be the First to Post Answer
Give the structure of the function ?
Talk about views
what is the cursor and use of cursor in pl/sql ?
What do you understand by pl/sql cursors?
define join and explain different type of joins? : Sql dba
how do you control the max size of a heap table? : Sql dba
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Explain how procedures and functions are called in a PL/SQL block ?
Can I join the same table twice?
What is difference between cursor and trigger?
What do you mean by rowid?
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)