Explain sql data types?

1137

What are the benefits of pl/sql packages?

1154

Does sql between include endpoints?

1056

Name the different types of indexes in sql and define them.

1220

What is primary key and unique key?

1160

What is 19 null in sql?

1016

Is pl sql still used?

1015

Can we update views in sql?

985

How to Execute a Package in PL/SQL.?

1276

How does sql*loader handles newline characters in a record? : aql loader

1088

What is the difference between join and natural join?

978

What is the difference between the sql*loader and import utilities? : aql loader

1086

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

2160

Which one is better subquery or joins?

1114

How do you use collections in procedure to return the resultset?

2279