code_junkie

Double Quotes in Oracle Column Aliases

Nov 10th, 2011
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT table1.Col1 AS "This is an alias" FROM table1
  2.  
  3. SQL Error: ORA-03001: unimplemented feature
  4. 03001. 00000 - "unimplemented feature"
  5. *Cause: This feature is not implemented.
  6.  
  7. SELECT table1.Col1 AS "This is |not| an alias" FROM table1
  8.  
  9. select 'test"columnname"' from dual
  10.  
  11. 'TESTCOLUMNNAME'
  12. --------------------------------
  13. test"columnname
  14.  
  15. select q'#someone's quote#' from dual;
Add Comment
Please, Sign In to add comment