sql in oracle

[Nikola Cavar]

Ziv!

Zanima me kako lahko z SQL stavk(i|om) najdem v kateri tabeli 
in v katerem stolpcu se nahaja poljubna beseda.

spisek vseh stolpcev in podatek v kateri tabeli se le ti nahajao
je mozno dobiti v user_tab_columns.

> SQL> desc user_tab_columns
>  Name                            Null?    Type
>  ------------------------------- -------- ----
>  TABLE_NAME                      NOT NULL VARCHAR2(30)
>  COLUMN_NAME                     NOT NULL VARCHAR2(30)
>  DATA_TYPE                                VARCHAR2(30)
>  DATA_TYPE_MOD                            VARCHAR2(3)
>  DATA_TYPE_OWNER                          VARCHAR2(30)
>  DATA_LENGTH                     NOT NULL NUMBER
>  DATA_PRECISION                           NUMBER
>  DATA_SCALE                               NUMBER
>  NULLABLE                                 VARCHAR2(1)
>  COLUMN_ID                       NOT NULL NUMBER
>  DEFAULT_LENGTH                           NUMBER
>  DATA_DEFAULT                             LONG
>  NUM_DISTINCT                             NUMBER
>  LOW_VALUE                                RAW(32)
>  HIGH_VALUE                               RAW(32)
>  DENSITY                                  NUMBER
>  NUM_NULLS                                NUMBER
>  NUM_BUCKETS                              NUMBER
>  LAST_ANALYZED                            DATE
>  SAMPLE_SIZE                              NUMBER
>  CHARACTER_SET_NAME                       VARCHAR2(44)
>  CHAR_COL_DECL_LENGTH                     NUMBER 

lp, nino.

-- 
int a=10000,b,c=2800,d,e,f[2801],g;main(){for(;b-c;)f[b++]=a/5;for(;d=0,g=c*2;c
-=14,printf("%.4d",e+d/a),e=d%a)for(b=c;d+=f[b]*a,f[b]=d%--g,d/=g--,--b;d*=b);}