Home » SQL & PL/SQL » SQL & PL/SQL » cannot insert data
cannot insert data [message #202260] Wed, 08 November 2006 21:48 Go to next message
ppong
Messages: 3
Registered: November 2006
Junior Member
hello
i want to insert data it fail why
code

insert into p_train_frm (train_id, train_title) values('01480',
'Students'||"'" ||' Perceptions of Effective
and Ineffective Clinical Instructors')

Re: cannot insert data [message #202264 is a reply to message #202260] Wed, 08 November 2006 22:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
my car won't go.
Tell me what is wrong with it.
Re: cannot insert data [message #202268 is a reply to message #202260] Wed, 08 November 2006 22:08 Go to previous messageGo to next message
ppong
Messages: 3
Registered: November 2006
Junior Member
eroor found
ORA-00984: column not allowed here
Re: cannot insert data [message #202270 is a reply to message #202260] Wed, 08 November 2006 22:09 Go to previous messageGo to next message
ppong
Messages: 3
Registered: November 2006
Junior Member
error found
ORA-00984: column not allowed here
i use oracle 8.15i
Re: cannot insert data [message #202277 is a reply to message #202270] Wed, 08 November 2006 22:31 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
insert into p_train_frm (train_id, train_title) values('01480', 
'Students'' Perceptions of Effective 
and Ineffective Clinical Instructors')


Ross Leishman
Re: cannot insert data [message #202278 is a reply to message #202260] Wed, 08 November 2006 22:31 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Google is your friend, but only if you use it.
I suspect unbalanced/misplaced single quote marks.
Previous Topic: UNION clause
Next Topic: Trigger for audit purpose
Goto Forum:
  


Current Time: Thu Dec 12 07:18:39 CST 2024