dejanj59
asked on
How to insert single quotes and double quotes into Oracle8i table
Dear All,
Does anyone know how to insert " (double quotes) and ' (single quotes ) into oracle8i table.
For example i 'v got a table :
CREATE TABLE "GCC"."SGCCSUSR"("ENCRYPTE D" VARCHAR2(132) NOT NULL);
..the value i need to insert is
18571!"#$% !"AEOLR% !"Dhrou(Hlvxz'vcpi%&'(#$%& '("#$%&'(" #$%&'(Dhro u(Ndwy&uio h$%&'(cbdv $% !"1214541015 !"DLLLWAB"#$% !" !" !" !"/
How do i do this?
Regards
Dejan
Does anyone know how to insert " (double quotes) and ' (single quotes ) into oracle8i table.
For example i 'v got a table :
CREATE TABLE "GCC"."SGCCSUSR"("ENCRYPTE
..the value i need to insert is
18571!"#$% !"AEOLR% !"Dhrou(Hlvxz'vcpi%&'(#$%&
How do i do this?
Regards
Dejan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Much appreciated. Oracle needs extra ' at the end of every ' plus i need to do another trick
with set define x where x is literal not in my character string so i pick ^
1) Insert ' at the end of every ' and run this in SQL*Plus to create a new record
set define '^';
INSERT
INTO GCC.SGCCSUSR
( ENCRYPTED )
VALUES
('18571!"#$% !"AEOLR% !"Dhrou(Hlvxz''vcpi%&''(#$
commit;
Dejan