im doing a project that needs to put a string into my oracle select statement. but it seems that the way to do it is to use REF CURSOR, and i notice that i have to code a long code in the cursor. is there any way to do it? i mean to avoid using ref cursor..btw im quite new pls help.
I don't really get your problem but it seems you are looking for something like this....
try this...in case you want the field concatenated with the field
select 'string '||<fields> from <tablename>;
this can also be
in case you only want the string as the output
select 'string ' from dual;
well, lets put it in a simple way, is there any way to execute a sql command that has string in it? say im refering to vb script actually...
something like this? :
this way i can append the string to my select statement without using ref cursor which will slow my code very much. any idea? thanks in advance