How to add comments on a table or a column.
If we want to give a comment on a table :
COMMENT ON TABLE
IS 'the comments should go here';
If we want to give a comment on a column :
COMMENT ON TABLE| COLUMN table.column
IS 'the comments should go here';
The entries of these comments on the table goes in the following tables:
For tables:
select * from all_tab_comments
where table_name ='table_name'
select * from user_tab_comments
where table_name = 'table_name'
For Columns:
select * from all_col_comments
where table_name = 'table_name'
select * from user_col_comments
where table_name = 'table_name'
COMMENT ON TABLE
IS 'the comments should go here';
If we want to give a comment on a column :
COMMENT ON TABLE
IS 'the comments should go here';
The entries of these comments on the table goes in the following tables:
For tables:
select * from all_tab_comments
where table_name ='table_name'
select * from user_tab_comments
where table_name = 'table_name'
For Columns:
select * from all_col_comments
where table_name = 'table_name'
select * from user_col_comments
where table_name = 'table_name'
10 comments:
best online dating web site http://loveepicentre.com/map.php what to write on dating profile
dating atmos clocks http://loveepicentre.com/ memphis dating toya
free pdf ebook proteomics http://audiobookscollection.co.uk/Digital-Logic-Circuit-Analysis-and-Design/p194868/ 2012 countdown ebook [url=http://audiobookscollection.co.uk/fr/CIO-Survival-Guide-The-Roles-and-Responsibilities-of-the-Chief-Information-Officer/p227809/]ebook royalty rate[/url] confederacy of dunces ebook
dune ebook download http://audiobookscollection.co.uk/Principles-of-Forensic-Medicine/p227599/ blog traffic blueprint ebook [url=http://audiobookscollection.co.uk/Mickey-Gousset/m89200/]heinlein robert a ebook[/url] university physics ebook by reese
tai chi ebook download torrent http://audiobooksworld.co.uk/it/B-Ireland/m10986/ motley crue the dirt ebook [url=http://audiobooksworld.co.uk/The-Hit-List/p18599/]ebook free mobipocket reader[/url] blackmask ebook iso cd download
ebook glass http://audiobooksworld.co.uk/Fatma-Ozcan/m37606/ bruce campbell ebook torrent [url=http://audiobooksworld.co.uk/Romance/c126/?page=42]ebook graduation[/url] td jakes ebook
[url=http://audiobooksworld.co.uk/fr/Sant-mente-corps/c1028/?page=2][img]http://audiobooksworld.co.uk/image/2.gif[/img][/url]
drum kit software http://buyoemsoftware.co.uk/fr/product-17635/FileSalvage-5-1-Mac supportsoft software inc [url=http://buyoemsoftware.co.uk/product-37266/SysDate-1-4]painting a room software[/url] acrobat writer 7 standard pdf software
[url=http://buyoemsoftware.co.uk/product-37100/Alabe-Reports-2-8]Alabe Reports 2.8 - Software Store[/url] xi tech recording software
[url=http://buyoemsoftware.co.uk/product-10107/Internet-TVRadio-Player-v5-1][img]http://buyoem.co.uk/image/7.gif[/img][/url]
[url=http://redbrickstore.co.uk/products/flagyl-er.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
neighborhood pharmacy in baltimore md http://redbrickstore.co.uk/products/trazodone.htm pharmacy south fork pa [url=http://redbrickstore.co.uk/products/zestril.htm]pharmacy drugs and medications r ranitidine[/url]
pet pharmacy 18008504419 http://redbrickstore.co.uk/products/gift-kamagra-jelly.htm what happened to doctor script online pharmacy [url=http://redbrickstore.co.uk/products/viagra-jelly.htm]viagra jelly[/url]
lupron pharmacy http://redbrickstore.co.uk/products/tenormin.htm pharmacy student soap note [url=http://redbrickstore.co.uk/products/tadacip.htm]medical pharmacy[/url]
twin knolls pharmacy http://redbrickstore.co.uk/products/actonel.htm adderol online pharmacy [url=http://redbrickstore.co.uk/products/erectalis.htm]erectalis[/url]
[url=http://certifiedpharmacy.co.uk/products/viagra-super-active-plus.htm][img]http://onlinemedistore.com/1.jpg[/img][/url]
nexium pharmacy purchase http://certifiedpharmacy.co.uk/products/bactroban.htm sc board of pharmacy [url=http://certifiedpharmacy.co.uk/products/serophene.htm]texas state pharmacy board[/url]
discount pharmacy home business on line http://certifiedpharmacy.co.uk/products/voltaren.htm pharmacys high point nc [url=http://certifiedpharmacy.co.uk/products/dilantin.htm]dilantin[/url]
care pharmacy http://certifiedpharmacy.co.uk/products/calan.htm freds pharmacy getwell memphis tennessee [url=http://certifiedpharmacy.co.uk/products/zocor.htm]pay less pharmacy british columbia[/url]
tramadol overnight pharmacy http://certifiedpharmacy.co.uk/products/singulair.htm docturate in pharmacy and health services [url=http://certifiedpharmacy.co.uk/products/metoclopramide.htm]metoclopramide[/url]
[url=http://englandpharmacy.co.uk/products/bupropion.htm][img]http://onlinemedistore.com/1.jpg[/img][/url]
protein powders pharmacy grade http://englandpharmacy.co.uk/products/karela.htm peral pharmacy clampham [url=http://englandpharmacy.co.uk/products/levitra-professional.htm]louisiana state pharmacy technician registration[/url]
prescriptions drugs pharmacy online http://englandpharmacy.co.uk/products/fincar.htm fda approved pharmacy by mail [url=http://englandpharmacy.co.uk/products/plendil.htm]plendil[/url]
kimberly sloan pharmacy http://englandpharmacy.co.uk/products/flagyl-er.htm isc portsmouth pharmacy [url=http://englandpharmacy.co.uk/products/methotrexate.htm]medicare moderization act any willing provider pharmacy[/url]
online cheap pharmacy http://englandpharmacy.co.uk/products/imuran.htm pharmacy benefit manager presentations [url=http://englandpharmacy.co.uk/products/levlen.htm]levlen[/url]
Post a Comment