What is function and procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Whis is not false in primary key?
how to use regular expression in pattern match conditions? : Sql dba
What is rownum in sql?
What is difference between procedure and trigger?
Differentiate between syntax and runtime errors.
What is index example?
What are the ways on commenting in a pl/sql code?
pl/sql testing means what ...... explain process how to find pl/sql bugs
Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.
What is pl/sql language case sensitive?
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.