my code stock.com

Enrique Castellanos

consulta características y comentarios de una tabla
by Enrique Castellanos

Snippet options

Download: Download snippet as consulta-caracteristicas-y-comentarios-de-una-tabla.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

SELECT CNAME,COLTYPE,--PRECISION,SCALE, 
       WIDTH,' ', 
       COMMENTS,DECODE(NULLS,'NOT NULL','N')
FROM COL, USER_COL_COMMENTS
WHERE TNAME ='TMP_CUADRO_B_C'
AND USER_COL_COMMENTS.TABLE_NAME = COL.TNAME
AND  USER_COL_COMMENTS.COLUMN_NAME = COL.CNAME
ORDER BY COLNO;

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.