L’inversione di tendenza ? ma speriamo di no, che l’Open Source abbia permesso a milioni di società e di individui singoli di poter accedere ,e dare il proprio contributo ,a Software prima inarrivabili è ormai noto. Era normale aspettarsi che tutti coloro che giustamente vivono sulle licenze dei “loro” software non vedano di buon occhio…
Leggi tutto
by using some simple view in Oracle you can extract a lot of information about your DB schema, some explicit samples : (assuming that MyDBOwner is the owner of the DB and ACTIVITY is a table of a schema, this sample is succesfully tested on Oracle 10g)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
-- LIST OF USERS select OWNER,COUNT(DISTINCT TABLE_NAME) from ALL_TAB_COLUMNS GROUP BY OWNER -- LIST OF TABLES PER OWNER select table_name from ALL_TAB_COLUMNS where owner = 'MyDBOwner' group by table_name -- LIST OF FIELDS PER TABLE select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE, CHAR_LENGTH from ALL_TAB_COLUMNS where owner = 'MyDBOwner' AND TABLE_NAME = 'ACTIVITY' -- FINDING PRIMARY KEYS select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE, CHAR_LENGTH from ALL_TAB_COLUMNS where owner = 'MyDBOwner' AND TABLE_NAME = 'ACTIVITY' -- A single character that indicates the type of constraint: 'C' = NOT NULL, 'P' = PRIMARY KEY, 'U' = UNIQUE, and 'R' = FOREIGN KEY. SELECT UC.CONSTRAINT_NAME, UCC.* FROM USER_CONSTRAINTS UC, USER_CONS_COLUMNS UCC WHERE UC.OWNER='MyDBOwner' AND UC.TABLE_NAME = 'ACTIVITY' AND UC.CONSTRAINT_TYPE = 'P' AND UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME |
a great article about this is :…
Leggi tutto
(This article is a draft but if something is of interesting …. ) The fantastic world of old Midas now called DataSnap introduced the TClientDataSet component , that is a in memory DataSet for Delphi and C++ Builder. With TClientDataSet was introduced the concept of Brief Case model Application Style. A brief case model App.…
Leggi tutto
Delphi was born exactly fifteen years ago from Today, Marco Cantu on his web site have posted a great article on this because he is one of the first guru of this beatifull dev language… the article
this article is a draft, but i published it because if you need something of that the resources that i found on internet are very interesting. mission of the post : mixing dynaic query and functions to allow join from db2db Dynamic SQL Great Article : http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/dynamic.htm#CHDGJEGD Dreate functions and consuming inside SQL , a…
Leggi tutto
[lang_it] Oggi è stata rilasciata la seconda versione del calendario di ZK ( articolo ufficiale : http://www.zkoss.org/product/zkcalendar.dsp) , non ho resistito son subito andato a provare la demo all’indirizzo http://zcal.zkoss.org/. La mia prima impressione è che sia molto ma molto più veloce delle precedenti, non sò bene perchè ma questa mi è balzata immediatamente all’occhio,…
Leggi tutto
