Jump to content

jaseervp@ymail.com

Members
  • Content Count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jaseervp@ymail.com

  • Rank
    Newbie
  1. 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 | -------------
  2. select to_char(birth_date,'DD-Mon-YYYY') from employee; -- oracle syntax
  3. .select trunc(Date_), sum(Amount) from TRANSACTIONSgroup by trunc(Date_)
  4. 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')
  5. 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
  6. 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
×
×
  • Create New...