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 1364
The 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
The 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
Why fastload support to empty table?
how to overcome kernel isssues544
how to restore particular schema from rman full backup?
user 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?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??463
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.1 1270
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
last function used in MS Access to convert sql what function will use in sql
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
Give two methods you could use to determine what DDL changes have been made.
Can you tell me how to add new column in existing views?how?How is possible?
can u give guidance abt packages of plsql
What are code pages ?
How can set the multipal database ?
In which table collections errors are stored.
What is the recommended interval at which to run statspack snapshots, and why?
How to do Data integrity testing? Who does this testing (Developer or tester)?
how can you attach more than 20 ldf files in sql server
what is ora 24313?what is the procedure to exclude that error?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
WHAT KIND OF TOOL BO IS?