Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to write down the comment in a database?

0 views
Skip to first unread message

Picaso....@gmail.com

unread,
Apr 29, 2008, 6:54:57 AM4/29/08
to
How to write down the comment in a database?

Example:

CREATE View:

CREATE VIEW test(COL1) AS
select /*1*/ 0 as col1, 1 as col2, 2 as col3, 3 as col4, 4 as col5, 5
as col6, 6 as col7, 7 as col8, 8 as col9, 9 as col10,
10 as col11, 11 as col12,12 as col13, 13 as col14, 14 as col15, 15 as
col16, 16 as col17, 17 as col18, 18 as col19, 19 as col110,
20 as col21, 21 as col22, 22 as col23, 23 as col24, 24 as col25, 25 as
col26, 26 as col27, 27 as col28, 28 as col29, 29 as col210
from dual;

EXECURE View:

CREATE VIEW test(COL1) AS
select 0 as col1, 1 as col2, 2 as col3, 3 as col4, 4 as col5, 5 as
col6, 6 as col7, 7 as col8, 8 as col9, 9 as col10,
10 as col11, 11 as col12,12 as col13, 13 as col14, 14 as col15, 15 as
col16, 16 as col17, 17 as col18, 18 as col19, 19 as col110,
20 as col21, 21 as col22, 22 as col23, 23 as col24, 24 as col25, 25 as
col26, 26 as col27, 27 as col28, 28 as col29, 29 as col210
from dual;

Kind Regards,
L.Picaso

Picaso....@gmail.com

unread,
Apr 29, 2008, 7:05:53 AM4/29/08
to
Create View in "Run SQL Command Line" Tool

Thanks.

0 new messages