what is difference between delete and truncate commands? : Sql dba
What is t sql used for?
what is a cursor? : Sql dba
Its possible to add more than one primary key for the table
What is a null value?
Can we use views in stored procedure?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
what is not null constraint? : Sql dba
Is pl sql still used?
List the differences between plsql - function & procedures
Can we create table inside stored procedure?
What are the different types of a subquery?
What is the use of sqlerrd 3?