OraFAQ Forum: Server Administration » INSERT WITH & AS FIELD VALUE FAILS

Home » RDBMS Server » Server Administration » INSERT WITH & AS FIELD VALUE FAILS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

INSERT WITH & AS FIELD VALUE FAILS [message #55868]

Thu, 20 February 2003 15:02

Jay
Messages: 127
Registered: October 1999

Senior Member

Hi Guys,
The following insert statement is failing its asking for & Federal value while insert can any one tell me how to insert this value in a table in bulk.

INSERT INTO T_LCSD_SCREEN_DETAIL
(SD_SCREEN_ID,SD_CTL_ID,SD_SEQUENCE_NO,SD_REF_NUM,SD_X,SD_Y,SD_BORDER,SD_BORDER_STYLE,SD_CTL_TYPE,SD_OBJECT_TYPE,
SD_BACK_COLOR,SD_TEXT_COLOR,SD_TEXT,SD_PICTURE,SD_MASK,SD_HEIGHT,SD_WIDTH,SD_FACE_NAME,SD_TEXT_SIZE,SD_WEIGHT,
SD_UNDERLINE,SD_ITALIC,SD_ORIG,SD_TBL_ORDER,SD_DSP_ONLY,SD_DATA_TYPE,TSTAMP)
VALUES
(10020,1,250,16,.75140924464487,.178033658104517,'N','B','FIELD','CBX',12632256,0,'&Federal','','',
73,321,'MS Sans Serif',-8,400,'N','N','Use Tax Table(0/1) for Fed',0,'N','','15-MAR-04')
/

Thanks for your help in advance

Report message to a moderator

Re: INSERT WITH & AS FIELD VALUE FAILS [message #55869 is a reply to message #55868]

Thu, 20 February 2003 15:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

mag@itloaner1_local > set scan off
mag@itloaner1_local > insert into test114 values ('AT&T');

1 row created.

Report message to a moderator

Re: INSERT WITH & AS FIELD VALUE FAILS [message #55878 is a reply to message #55868]

Fri, 21 February 2003 08:08

ctg
Messages: 146
Registered: July 2002

Senior Member

something else that will work:

in sqlplus:
SQL> show define -- shows the character sqlplus uses to signify a substitution variable (& is default)
SQL> set define off

Report message to a moderator

Previous Topic:	OEM Console HELP!!
Next Topic:	Listener Won't Start from Startup Script - 8.1.7.4 Solaris 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:55:14 CDT 2024