-
Help me out with query
Can some one help me how to write spool scripts to join 2 statements and execute as one. this will fetch 2000 records. I need to substitute id, empid,psvers values in the call statement.
select id, empid, psvers from tbl_prod where id > 180;
call image('id','empid', psvers, 'format=jfif');
thanks
-
I haven't the slightest clue what you are trying to do...
Jeff Hunter
-
i think he wants the output from the first query to be the input to the procedure
but that is basic plsql block, so google for it :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|