Home » SQL & PL/SQL » SQL & PL/SQL » insert or update
insert or update [message #232992] Tue, 24 April 2007 06:39 Go to next message
shivakumarag
Messages: 6
Registered: April 2007
Location: india
Junior Member
hi
how can i update row
type='goods P&L payment'
there is a need to insert or update into table
this value 'goods P&L payment'
i cannot insert then as 'goods P and L payment'
it asks like variable enter value
thanxs
Re: insert or update [message #232996 is a reply to message #232992] Tue, 24 April 2007 06:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Issue this command in SQL*Plus:
SET DEFINE OFF

'&' is the default substitution marker in SQL*Plus, which is why it is asking you for the value of what it sees as a substitution variable.
Re: insert or update [message #233007 is a reply to message #232996] Tue, 24 April 2007 06:54 Go to previous messageGo to next message
shivakumarag
Messages: 6
Registered: April 2007
Location: india
Junior Member
hi
gr8 good
thx
Re: insert or update [message #233110 is a reply to message #233007] Tue, 24 April 2007 14:45 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
shivakumarag wrote on Tue, 24 April 2007 06:54
hi
gr8 good
thx

Just a mild rebuke. Many of our members are not English speaking or don't even have cell phones. Please do not use IM speech. it confuses many people who doesn't grasp your meaning.
Previous Topic: Re-Compiling package
Next Topic: Table Designing
Goto Forum:
  


Current Time: Tue Dec 06 02:39:53 CST 2016

Total time taken to generate the page: 0.15495 seconds