How to perform a loop through all tables in pl/sql?
Answers were Sorted based on User's Feedback
Answer / chandrakant rathod
We can get all tables for particular instance using below block .
SET SERVEROUTPUT ON;
for rec in (select object_name from user_objects where object_type='TABLE')
|Is This Answer Correct ?||5 Yes||0 No|
Answer / highness
I got a lot of definitions for this but i thing this is right
A compiled plsql procedure
stands for a stored procedure...
check out this
|Is This Answer Correct ?||1 Yes||2 No|
Answer / mahesh gulati
select * from sysobjects where type = 'u'
|Is This Answer Correct ?||3 Yes||6 No|
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is difference between inner join and self join?
What has stored procedures in sql and how we can use it?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is a rank in sql?
What is the difference between row level and statement level trigger?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....
how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
Is it possible to access the current value in a session before accessing next value?
What is sql procedures and functions?
Can we use update in sql function?