how can we destroy the session, how can we unset the variable of a session? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
Does truncate table reset auto increment?
What are the attributes of SQL*PLUS ?
Is primary key an index?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
select sal from emp group by sal
Does varchar need length?
what is definer rights invoke rights?
Why use truncate instead of delete?
Give the structure of the function ?
What will happen after commit statement ?
What are views in sql?