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?
-------------
| id | name |
|----------- |
| 1 | null |
| 2 | BANK |
-------------
expected result is:
-------------
| id | name |
|-------------|
| 1 | |
| 2 | BANK |
-------------
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