|
|
Re: how to insert this value into table in oracle [message #6566 is a reply to message #6563] |
Fri, 25 April 2003 03:52 |
Giridhar
Messages: 38 Registered: May 2001
|
Member |
|
|
SQL> insert into inagkod (table_name) values ('NACT'||'&'||'ACCT');
1 row created.
SQL> select * from inagkod where table_name like 'NAC%';
TABLE_NAME COLUMN_NAME INDEX_NAME
-------------------- -------------------- --------------------
NACT&ACCT
SQL> show define
define "&" (hex 26)
SQL> set define off
SQL> insert into inagkod (table_name) values ('NACT&ACCT');
1 row created.
SQL> select * from inagkod where table_name like 'NAC%';
TABLE_NAME COLUMN_NAME INDEX_NAME
-------------------- -------------------- --------------------
NACT&ACCT
|
|
|
|
Re: how to insert this value into table in oracle [message #6601 is a reply to message #6566] |
Mon, 28 April 2003 05:54 |
BABU SRSB
Messages: 42 Registered: June 2002
|
Member |
|
|
Hi All,
With out choosing SQL Plus commands also, you can insert the '&' character into the table.
check the below one.
SQL> desc ex;
Name Null? Type
------------------------------- -------- ----
ENO NUMBER
ENAME VARCHAR2(10)
SQL> select * from ex;
ENO ENAME
--------- ----------
1 sita
2 gita
SQL> insert into ex values (3, 'sita'|| chr(38) ||'gita');
1 row created.
SQL> select * from ex;
ENO ENAME
--------- ----------
1 sita
2 gita
3 sita&gita
SQL>
Have a nice day,
Babu SRSB
|
|
|