Are pl sql variables case sensitive?
What is the difference between sql and t sql?
What is the purpose of the sql select top clause?
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
Compare SQL and PL/SQL.
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
write a query to find 4th max salary
What are the sql aggregate functions?
What is the plv (pl/vision) package offers?
What is full join?
How does postgresql compare to mysql?