OraFAQ Forum: Server Administration » is this possible in 8i

Home » RDBMS Server » Server Administration » is this possible in 8i

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

is this possible in 8i [message #58114]

Fri, 01 August 2003 20:35

sidd
Messages: 130
Registered: May 2003

Senior Member

is this possible in 8i?
how do i do this if anything wrong in this stmt.

if exits (select 1 from tst where id=l_id) then
update tst set id = l_id, naam=l_naam, addr=l_addr, comments=lrtrim(ltrim(l_comments,'~'),'~') where id=l_id;
else
insert into tst ( id, naam,addr, comments ) values ( l_id,l_naam,l_addr, rtrim(ltrim(l_comments,'~'),'~') );
end if;

Report message to a moderator

Re: is this possible in 8i [message #58121 is a reply to message #58114]

Sat, 02 August 2003 20:48

sidd
Messages: 130
Registered: May 2003

Senior Member

Take it easy guys. i got the answer that IF stmt

Report message to a moderator

Previous Topic:	in-line view
Next Topic:	run oracle process on the root directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:22:31 CDT 2024