Home » RDBMS Server » Server Administration » sql basic question (the nop problem)
sql basic question (the nop problem) [message #372377] Tue, 06 February 2001 14:38 Go to next message
Pepe
Messages: 2
Registered: February 2001
Junior Member
Hi.
I'm looking into sending a SQL command that would do nothing, in order to do some kind of keepalive on a connection. Do you have any idea? (must not be oracle specific)

Report message to a moderator

Re: sql basic question (the nop problem) [message #372380 is a reply to message #372377] Tue, 06 February 2001 15:53 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
Sounds like a nasty workaround...

you could try something like :

select 'x' from mytable where 1=2;

pl/sql would be ...
begin
null;
end;

...but that is oracle specific.

Report message to a moderator

Previous Topic: cannot delete*from
Next Topic: sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jun 10 14:17:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.