Hello

i want to create one cursor with null values.
like
Cursor test is
Select a,b,c,d,e,f,g,h,i,j,k from dual

After this i want to pass values for a,b,c,d in that cursor
Once it is done, again i want to pass values for
a,b,e,f, after this once again
i want to pass values to a,b,g,h

Can i do that , if S please give me some code sample.

I have one SQL in which for now we are creating one
temp table and in each SQL we are inserting values into
required columns in that temp table

Finally we are taking values from temp , combining
with other main tables.

Now are forced to go for PL/SQL so ..let me know
what i can do for this

Is it possible to insert only some column values in
cursor...

Thanks

I don't understand what you are trying to do, really. You can't select a,b,c,... from dual because table dual doesn't possess such columns:

SQL> select a,b,c from dual;
select a,b,c from dual
*
ERROR at line 1:
ORA-00904: invalid column name

But let's suppose you are really selecting from another table:

SQL> create table t1 (a int, b int, c int);

Table created.

Now, you can set values in the cursor record like this:

Is that what you meant?