
Untitled
By: a guest on
May 5th, 2012 | syntax:
None | size: 0.48 KB | hits: 13 | expires: Never
Is it compulsory to use aliases in a Select Query in Oracle?
Name NameType(name VARCHAR2(30), surname VARCHAR2(30),
Address AddressType(First_Line VARCHAR2(30), City VARCHAR2(30), Post_Code VARCHAR2(8),
Salary NUMBER)
SELECT City
FROM Manager
Where name like 'Jim';
SELECT m.address.city from Manager m
WHERE m.name.f_name LIKE 'Jim' AND m.name.l_name LIKE 'Smith';
SELECT salary
FROM Manager
WHERE name like 'J%';
SELECT m.Salary
FROM Manager m
WHERE name like 'J%';