INNER JOIN

Syntax:

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name;


Example:

select *
from CST_KFH_USER cu
inner join CST_USER_GROUP cst
on cu.GROUP_ID=cst.GROUP_ID where  cu.u_deleted=0 order by cu.user_alias desc;

Return null as 0 in oracle select statement

Return null as 0 in oracle select statement

select nvl (sum(com.AMOUNT),0) from EPF e inner join bib_company_transaction com on e.parent_oid = com.trnx_id where status='T' and com.UPDATED_DATE between to_date('20111018', 'yyyymmdd') and to_date('20111019', 'yyyymmdd')

Show Full SQL Developer Timestamp

Cara pertama:

One time solution only! 

alter session set nls_date_format = 'MM/DD/YYYY HH24:MI:SS'; 

Cara kedua:

Tools -> Preferences -> Database -> NLS Parameters

Change Date Format to DD-MON-RRRR HH24:MI:SS

Cara no2 ni boleh guna sampai bila2.. hehehe

Gud Luck!