Oracle update statement help

[davechunny]

I need to create a update statement with the ":" character in it. but I'm having trouble. My update statement is:

update ORDR set ORDR.TRANS_ID ='115::Y:' Where ORDR.ORDR_NUM = '12345';

Can someone tell my how to write this properly? Thanks!!

[pankajkumar]

I need to create a update statement with the ":" character in it. but I'm having trouble. My update statement is:

update ORDR set ORDR.TRANS_ID ='115::Y:' Where ORDR.ORDR_NUM = '12345';

Can someone tell my how to write this properly? Thanks!!

*********************
Try the below..example, it works fine.

SQL> desc a;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
GENDER VARCHAR2(20)

SQL> select * from a;

ID GENDER
---------- --------------------
1 m
2 f
3 m
4 m

SQL> update a set gender='abc::abc:' where id=1;

1 row updated.

SQL> select * from a;

ID GENDER
---------- --------------------
1 abc::abc:
2 f
3 m
4 m