|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
|
|||
|
|||
|
ANSI SQL-92 to Oracle
Hi guys, I have this SQL statement in ANSI SQL-92. I just found out that Oracle 8i doesn't support ANSI SQL-92 for left joins. How do I translate it to Oracle's native SQL?
Code:
select a.no_gaji, a.nama, a.no_kp, a.no_tel, a.staf_ketagori, a.trk_lahir, a.trk_lantikan, a.kod_warga, a.kod_jab, a.taraf_khidmat, a.no_kwsp, a.tkh_tamat_kontrak, b.gaji, c.per_jab, d.per_warga, e.per_khidmat from gaj_induk a left join gaj_jadual2 b on (a.kod_gaji = b.kod_gaji and a.rank_gaji = b.rank_gaji and a.t_gaji = b.t_gaji) left join gaj_kod_jab c on (a.kod_jab = c.kod_jab) left join gaj_kod_warga d on (a.kod_warga = d.kod_warga) left join gaj_kod_khidmat e on (a.taraf_khidmat = e.taraf_khidmat) where a.no_gaji = 00000790 Thanks. |
|
#2
|
||||
|
||||
|
Read this article, that points out the old (non standard) and the new sql syntax for joins in Oracle.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#3
|
|||
|
|||
|
thanks for the article.
helped a lot. cheers. |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > ANSI SQL-92 to Oracle |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|