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
|
