SQL Select statement

[email protected] Wed, 29 Jan 2003 17:34:34 +0800

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-852908-2003.01.29-09.48.58--gcdod-oracle#[email protected]>

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?

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?

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).

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 protected].