What is the difference between inner join and left join?
Is full outer join same as cross join?
What is a constraint? Tell me about its various levels.
What is execute immediate?
What are nested triggers ?
6 Answers Amazon, Appeal Soft, IBM, Infosys, TCS,
How will you select unique values from a list of records?
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w
4 Answers Scope International,
What are the PL/SQL Statements used in cursor processing ?
How do you get column names only for a table (sql server)?
What is parameter substitution in sql?
What is clause in sql?
I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body