jaseervp@ymail.com

hello,

I have a table, that contains null in one column. when I query on that table null is also appearing in the result. Is there any option to hide the null?

select to_char(birth_date,'DD-Mon-YYYY') from employee;

-- oracle syntax

.select trunc(Date_), sum(Amount) from TRANSACTIONSgroup by trunc(Date_)

you can use trigger

select * from employees whereSub = 'REG' and Department IN ('QA', 'Engineering', 'Assembly')and EmployeeID not in (select EMP_ID from attendance_log where trunc(LOG_TIME)='02-05-2013')

If you are deleting data from a huge table, fire commit in a regular interval(eg: execute commit after deleting each 1000 rows). It will help to reuse the undo/rollback space

select column_name , 'table1' as Table from table1unionselect column_name , 'table2' as Table from table2unionselect column_name , 'table3' as Table from table3 You can identify the table name form Table