RE: SQL Select statement

-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Wednesday, January 29, 2003 4:35 AM
To: Oracle
Subject: [oracle] SQL Select statement


Hi,

I am new to Oracle database. There are a few things that I need help.

1) As we know, the LIKE operator in SQL statement will not return the field
which is NULL.
    So, what can we do in order for the field which is NULL to be return?

select field where field is null or field like 'a%';

2) In SQL Server, it is possible to select a column using another SQL
statement.
     Eg. select abc, (select sum(def) from B), ......
     I tested using Oracle SQLPlus, and keep getting the error message
missing expression.
     How to accomplish this in Oracle?

select t1.fielda, t2.fieldb
from table1 t1, table2 t2
where t1.keyfield = t2.keyfield
and etc..... 

3) What is the best reference to look for to get started with Oracle
database?
     Eg, how do we know what features are available in Oracle and how to
use it (syntax).

Oracle PL/SQL Programming by Feuerstein is an excellent book, books by TUSC
are excellent also.. plus Oracle Press has some very good books... 

Thank you in advance for the help.

Best Regards,
- nicole -


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.




---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].