Create a procedure to delete certain records from a table
and display the total number of records deleted in this
process. (Condition for deletion can be of ur choice, for
instance delete all records where eid='')
Answers were Sorted based on User's Feedback
Answer / manas
create or replace procedure proc_name(noofcount out number ) is
Begin
Delete from tes_tabt;
noofcount := sql%rowcount;
End
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / mathivanan
Create or replace procedure delete_rec_cnt is
begin
delete from MY_TABLE;
dbms_output.put_line(sql%rowcount);
end;
Is This Answer Correct ? | 1 Yes | 0 No |
List and explain the different types of join clauses supported in ansi-standard sql?
What is inner join in sql?
How to pronounce postgresql?
Can dml statements be used in pl/sql?
What is input buffer in sql*plus?
What is sql query optimization?
what is global table
what is julian date in oracle
3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
what is a record in a database ? : Sql dba
Why query optimization is needed?
Is pl sql still used?