Is a foreign key always unique?
Why do we use subquery?
what is a stored procedure? : Sql dba
Does varchar need length?
What is the difference between in and between in sql?
What are % type and % rowtype?
What is loop in pl sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is data abstraction in sql?
How to add a column ‘salary’ to a table employee_details?
Is sql sequential or random?
Can unique keys be null?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How can you create an empty table from an existing table?
What are the different types of constraints?