Nov 28, 2007 #1 makk07 Programmer Joined Aug 22, 2007 Messages 24 Location US Hi Everyone, Anybody please let me know where can I get the technical support for oracle 9i views. Thanks in advance! mak07
Hi Everyone, Anybody please let me know where can I get the technical support for oracle 9i views. Thanks in advance! mak07
Nov 28, 2007 #2 SantaMufasa Technical User Joined Jul 17, 2003 Messages 12,588 Location US Mak said: ...where can I get the technical support for oracle 9i views. Click to expand... What do you mean by technical support? Do you mean documentation? (If so, you can Google for "Oracle VIEW syntax" and receive 1M+ hits.) Syntax for Oracle VIEWs is pretty simple...get a SELECT query running as you want, then place the words: Code: CREATE VIEW <view_name> AS <your SELECT statement here>; Each of the resulting columns' name/label must conform to Oracle's column-name conventions. Let us know if you have additional questions. Mufasa (aka Dave of Sandy, Utah, USA) [I provide low-cost, remote Database Administration services: www.dasages.com] Upvote 0 Downvote
Mak said: ...where can I get the technical support for oracle 9i views. Click to expand... What do you mean by technical support? Do you mean documentation? (If so, you can Google for "Oracle VIEW syntax" and receive 1M+ hits.) Syntax for Oracle VIEWs is pretty simple...get a SELECT query running as you want, then place the words: Code: CREATE VIEW <view_name> AS <your SELECT statement here>; Each of the resulting columns' name/label must conform to Oracle's column-name conventions. Let us know if you have additional questions. Mufasa (aka Dave of Sandy, Utah, USA) [I provide low-cost, remote Database Administration services: www.dasages.com]