Commentaire table oracle

COMMENT ON TABLE table_name IS 'A table comment';
COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment';

SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';

Similar codes

0 vote233 views1 answer
Php insert null mysql
SQL
0 vote179 views1 answer
Mysql update from select on same table
SQL
0 vote174 views1 answer
Write a query to peint the pattern P(20)
SQL
8 votes211 views1 answer
See all users mysql
SQL
0 vote219 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote170 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote190 views2 answers
Sql stored procedure for access frontend
SQL
0 vote291 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote167 views1 answer
Select from another database
SQL
1 vote199 views1 answer
Pentaho + pasar de excel a sql
SQL