Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Technical Support for Oracle 9i Views

Status
Not open for further replies.

makk07

Programmer
Aug 22, 2007
24
US
Hi Everyone,

Anybody please let me know where can I get the technical support for oracle 9i views.

Thanks in advance!
mak07
 
Mak said:
...where can I get the technical support for oracle 9i views.
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.


[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top