Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 5th, 2012  |  syntax: None  |  size: 0.48 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Is it compulsory to use aliases in a Select Query in Oracle?
  2. Name NameType(name VARCHAR2(30), surname VARCHAR2(30),
  3. Address AddressType(First_Line VARCHAR2(30), City VARCHAR2(30), Post_Code VARCHAR2(8),
  4. Salary NUMBER)
  5.        
  6. SELECT City
  7. FROM Manager
  8. Where name like 'Jim';
  9.        
  10. SELECT m.address.city from Manager m
  11. WHERE m.name.f_name LIKE 'Jim' AND m.name.l_name LIKE 'Smith';
  12.        
  13. SELECT salary
  14. FROM Manager
  15. WHERE name like 'J%';
  16.        
  17. SELECT m.Salary
  18. FROM Manager m
  19. WHERE name like 'J%';