No Answer is Posted For this Question
Be the First to Post Answer
How do you write a subquery?
real time applications of nullif?
What are database links used for?
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.
Give an example of any procedure.
How do we tune the code?
What are the various restrictions imposed on view in terms of dml?
What is the use of sql trace?
What is difference between cursor and trigger?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What are the types of views in sql?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???