| create view [message #374260] |
Sun, 03 June 2001 14:21  |
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.....
|
|
|
|
| Re: create view [message #374290 is a reply to message #374260] |
Mon, 04 June 2001 12:28  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
|
No you cant. The datatype, lengths and NULL/NOT NULL are all inherited from the underlying SQL query. You can use nvl() in the underlying SQL to ensure NOT NULL, substr to limit the size of a tring or to_char(), to_number(), to_date() etc to change datatype.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
