var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OFF keyword in SQL Oracle
I was looking at a view, and found somewhere in the where/select clause the "off" keyword is being used, i tried to google it, could not find anything.
It goes this way
select off.col1, col2 ...
select col1,col2 from .. where off.col3 ...
Anyone has any idea what the off keyword represents
As far as I can tell, it is not a keyword but a table alias.
SQL> select off.deptno, off.dname
2 from dept off
3 where off.loc = 'BOSTON';
oh yeah, you are right, its an alias, i dont know why this guys uses such an alias, in TOAD, the "OFF" word was highlighted in blue, so i was thinking it was a keyword, thanks for the help
Originally Posted by Littlefoot