Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Table of dynamic SQL queries

Re: Table of dynamic SQL queries

From: stu <smcgouga_at_nospam.co.uk>
Date: Thu, 13 Feb 2003 15:23:43 -0000
Message-ID: <b2gdcm$i0n$1$830fa17d@news.demon.co.uk>


Yes, like a collection of queries in a table. I did not know that rdbms stored views as a table of sql statments. Need to go and think how i could use my new found know how now!

Cheers
Stu
"Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message news:b2g12u$sbm$1_at_sp15at20.hursley.ibm.com...
> "stu" <smcgouga_at_nospam.co.uk> wrote in message
> news:b2fubq$99r$1$8300dec7_at_news.demon.co.uk...
> > Has anybody ever used/thought about a table of sql statements?
> > create table SQL(Title varchar * 20, SQLText Memo)
> >
> > Where you can store dynamic sql to be executed at runtime. This
structure
> > could prove very flexible. You could also implement custom
searches/reports
> > for users in jig time!
>
> Er isn't that what VIEWs are?
>
> db2 select substr(TEXT,1,60) from syscat.views fetch first 5 rows only
>
> 1
> ------------------------------------------------------------
> CREATE VIEW SYSIBM.CHECK_CONSTRAINTS (CONSTRAINT_CATALOG, CO
> CREATE VIEW SYSIBM.COLUMNS ( TABLE_CATALOG, TABLE_SCHE
> CREATE VIEW SYSIBM.COLUMNS_S ( TABLE_CATALOG , TABLE_
> CREATE VIEW SYSIBM.REFERENTIAL_CONSTRAINTS ( CONSTRAINT_
> CREATE VIEW SYSIBM.REF_CONSTRAINTS ( CONSTRAINT_CATALOG
>
> 5 record(s) selected.
>
>
> Regards
> Paul Vernon
> Business Intelligence, IBM Global Services
>
>
Received on Thu Feb 13 2003 - 09:23:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US