7. Where would you look for errors from the database design?
What is pl sql variable?
in a package one procedure is wrong package shows valid or not
Explain the rollback statement?
can i create trigger on synonym is it possible or not please help me
List the differences between plsql - function & procedures
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
25.67,-1 Trunc = 20 Round= 30 HOW????
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
how to get a list of all tables in a database? : Sql dba
what is explain plan?
What is function and procedure?
How do you get column names only for a table (sql server)?
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)