Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of normalization?
Does asenumerable execute the query?
25.67,-1 Trunc = 20 Round= 30 HOW????
What does select top 1 do in sql?
What is query execution plan in sql?
what are the differences between char and nchar? : Sql dba
when is the use of update_statistics command? : Sql dba
Difference between IN and EXISTS
Which command is used to delete a trigger?
What are the different types of triggers?
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
Can we relate two different tables from two different users in ORACLE,PL/SQL?
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)