Home » RDBMS Server » Server Administration » query
query [message #370752] Mon, 31 January 2000 00:37 Go to next message
shailedra
Messages: 2
Registered: January 2000
Junior Member
I need help to solve following query in oracle.
We have scott/tiger login.
We have DEPT table containing 4 records.
I want following query in sigle sql statement-
IF (LOC IS NULL) THEN
SELECT * FROM DEPT;
ELSE SELECT * FROM DEPT WHERE LOC='BOSTON';
END IF;

Report message to a moderator

Re: query [message #371401 is a reply to message #370752] Fri, 13 October 2000 06:45 Go to previous message
Thiyagarajan
Messages: 9
Registered: October 2000
Junior Member
Could you rephrase the question.

Report message to a moderator

Previous Topic: Cursor over two schemas?
Next Topic: date calculation routine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 15:51:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.