Article View: es.comp.lenguajes.java
Article #27037Re: JDBC.
From: Rafael Garcia Leiva
Date: Thu, 05 Nov 1998 00:00
Date: Thu, 05 Nov 1998 00:00
17 lines
945 bytes
945 bytes
[Posted and mailed]
In article <71pvb9$pf9@tid.tid.es>,
"Javi" <jrs53@tid.es> writes:
> �Como saco de una base de datos el numero de tablas, nombre de tablas,
> permisos, etc...?
>
Con simples consultas SQL, en oracle por ejemplo seria:
* numero de tablas:
select count(*) from all_tables;
* nombre de las tablas:
select table_name from all_tables;
y asi con todo, all_users, etc.
Technical Details
Message-ID:
<71rn5b$i5i$2@mercurio.cica.es>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<71pvb9$pf9@tid.tid.es>Show Full Headers
Complete Article Headers
X-Google-Language: SPANISH,ASCII X-Google-Thread: 1116f3,76734ae1e2e5236 X-Google-Attributes: gid1116f3,public From: cc1galer@uco.es (Rafael Garcia Leiva) Subject: Re: JDBC. Date: 1998/11/05 Message-ID: <71rn5b$i5i$2@mercurio.cica.es> X-Deja-AN: 408617481 Content-Transfer-Encoding: 8bit References: <71pvb9$pf9@tid.tid.es> To: "Javi" <jrs53@tid.es> Content-Type: text/plain; charset=iso-8859-1 Organization: Centro Informatico Cientifico de Andalucia Mime-Version: 1.0 Newsgroups: es.comp.lenguajes.java