This content has been marked as final. Show 4 replies
What ever you are trying is wrong.
Second this Table Alias is provided in order to differentaite when you have gone for any self joins on same table and easy of use.
You can not create an Alias like that. Might be you are thinking of Synonyms.
create public synonym
create table test1 (a number);
create synonym t1 for test1;
Refer : http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/views.htm
- Pavan Kumar N
Edited by: Pavan Kumar on Nov 30, 2008 9:23 AM
ok, I do use it in the join case, here it is. My problem is that, sql does not accept my aliasing.
SELECT aptname, manager_id
FROM MANAGER_UNITS AS "M", LEASE AS "L", PAYMENT AS "P"
WHERE M.aptname =L.aptname AND M.unit# = L.unit AND P.rid = L.rid;
so my aliases are M and L and P. But for some reason this does not work. What is incorrect? Thank you
Edited by: user10653046 on Nov 29, 2008 8:20 PM
Why are you putting your aliases in double-quotes? Quoting any identifier in Oracle makes that identifier (alias, table name, column name, etc) case sensitive. If your alias contains non-uppercase letters, every time you reference that identifier, you would have to put the identifier in double quotes and get the casing correct.
99+% of the time, the best answer is just to use Oracle's default case insensitivity and not double-quote identifiers.