OraFAQ Forum: SQL & PL/SQL » Syntax for creating views

Home » SQL & PL/SQL » SQL & PL/SQL » Syntax for creating views

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Syntax for creating views [message #10738]

Fri, 13 February 2004 09:34

aileen
Messages: 8
Registered: January 2004

Junior Member

What is the correct syntax for creating a view of a single table?

�

Report message to a moderator

Re: Syntax for creating views [message #10739 is a reply to message #10738]

Fri, 13 February 2004 09:37

sverch
Messages: 582
Registered: December 2000

Senior Member

create or replace view as select....FROM...WHERE...

Report message to a moderator

Re: Syntax for creating views [message #10740 is a reply to message #10739]

Fri, 13 February 2004 09:40

aileen
Messages: 8
Registered: January 2004

Junior Member

If there is only one table is the WHERE line still required? Do you use ; or / to finish the statement?

Getting an error when trying to compile:

ERROR at line 29:
ORA-00936: missing expression

Report message to a moderator

Re: Syntax for creating views [message #10741 is a reply to message #10740]

Fri, 13 February 2004 09:43

aileen
Messages: 8
Registered: January 2004

Junior Member

Problem solved. Thanks for the help!!

Report message to a moderator

Previous Topic:	update set problem
Next Topic:	Materialazed views.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:49:01 CDT 2024