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.
2 2633The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
TCS,
1 2464The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
TCS,
2 3150user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
HCL,
1 2388HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
1070how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
1 2484
How delete all data from table in sql?
Why do we need cursors in pl sql?
what is try_catch block in procedure
What is subquery? Explain the properties of a subquery?
Should I use mbr or gpt?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is user-defined functions? What are the types of user-defined functions that can be created?
How do you maintain a database?
What is normalisation and its type?
what is the full procedure for using store procedure in informatica7.1?
What is a temporal data type?
What does it mean to normalize a database and why would you do it?
Mention how you can inspect the source code of a function?
What is implicit cursor in dbms?
If I use netlib, will I find many other users to network with?