Home » RDBMS Server » Server Administration » create view
create view [message #374259] Sun, 03 June 2001 14:20
misheL
Messages: 3
Registered: June 2001
Junior Member
can i include in creating view data type and sizes and what is right syntax for that....following syntax seems not right..

CREATE OR REPLACE VIEW1_VW
(NAME VARCHAR2(20),
ADDRESS VARCHAR2(40),
CITY VARCHAR2(20),
POST_DATE DATE NOT NULL)AS.....

Report message to a moderator

Previous Topic: Re: What is use of 'raise' command in pl/sql
Next Topic: updating table with another table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 13:35:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.