need explainantion about sql quries..

[rengaraj]

hi frens

I want to know some information/ explaination from SQL.. I want to know about join queries, subquries, timestamps, date_part, date_trunc, case and cast data type..



Do anyone there can help to expain in details or give me some links tutorial where i can understand easily about tis quries..
thanks

[debasisdas]

Please find the related articles in the Oracle Howto section of the forum.

[subashsavji]

go through sql volume-I and II certification book. there definately you will get solution.

[sahilora]

hi frens

I want to know some information/ explaination from SQL.. I want to know about join queries, subquries, timestamps, date_part, date_trunc, case and cast data type..



Do anyone there can help to expain in details or give me some links tutorial where i can understand easily about tis quries..
thanks

go through some pl/sql book subqueries are logic based in which inner queries are of great interests as outer queries depend upon result given by inner queries.
if you want to kow about subqueries then break the whole queries into independent part''''......example
SQL> select * from emp where
sal in(select sal from emp where salary not in(5000,3000,11000));