how do form this string? [message #282893] |
Sat, 24 November 2007 14:29  |
futi
Messages: 22 Registered: November 2007
|
Junior Member |
|
|
hi.. i am newbie for oracle. I have an easy question.
I will create a dynamic sql.
Such as:
vName:='MYDIR';
path:='C:\ORACLE\';
sqlStr:='CREATE OR REPLACE DIRECTORY ' ||vName|| ' AS ' ||path||;
so the output of string must same :
CREATE OR REPLACE DIRECTORY MYDIR AS 'C:\ORACLE\';
the ' character must placed in string. How can i do this? With q'?
then, i must run this sql string. But how?
thanx
|
|
|
|
|