jpundalik

 Profile Answers by jpundalik 

• Dec 29th, 2009

 

Below is the syntax for creating the view (simple view)

create view <view_name> as select * from <table_name> [where condistions]

Example

create view emp_vw as select * from emp where emp_id ='12345';

pravintule

 Profile Answers by pravintule 

• May 28th, 2010

 

CREATE or REPLACE VIEW <view_name> as (SELECT Statment)

sravani

 Profile Answers by sravani 

• Aug 4th, 2010

 

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

rahulansi

 Profile Answers by rahulansi 

• Aug 22nd, 2010

 

CREATE VIEW <view name> as SELECT <statement> FROM <table name> WHERE <condition>

abinitiohari

 Profile Answers by abinitiohari 

• Jan 30th, 2011

 

CREATE VIEW v1
AS
SELECT * FROM emp;