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;
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.
Previous Topic: Cursor over two schemas?
Next Topic: date calculation routine
Goto Forum:
  


Current Time: Fri Mar 29 03:39:59 CDT 2024