Home » SQL & PL/SQL » SQL & PL/SQL » Output of the query (Oracle9i)
Output of the query [message #403495] Fri, 15 May 2009 20:32 Go to next message
sharmakranthi
Messages: 14
Registered: February 2009
Location: Bangalore
Junior Member
Since Oracle DB is not working in my PC, i am requesting you give the result of the below mentioned code.

select empid from employee where (salary*12)>=70000


Please dont scold for asking like this
Re: Output of the query [message #403503 is a reply to message #403495] Sat, 16 May 2009 00:36 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Why is Oracle "not working" on your computer?
Did you try to install Oracle XE?
Re: Output of the query [message #403508 is a reply to message #403495] Sat, 16 May 2009 01:38 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
i am requesting you give the result of the below mentioned code.

SQL> select empid from employee where (salary*12)>=70000
  2  /
select empid from employee where (salary*12)>=70000
                  *
ERROR at line 1:
ORA-00942: table or view does not exist

Regards
Michel
Previous Topic: query problem
Next Topic: Time data type column
Goto Forum:
  


Current Time: Sat Dec 07 05:45:51 CST 2024