Re: [?] Command USE using Oracle db

Sigh! For your reference, ALL Oracle documentation is available at http://docs.oracle.com - this question is covered in the Database Administrator's Guide appropriate to the release (version) of the database you are using.

What MS SQL-Server calls a 'database' is generally similar to a 'schema' in Oracle. You either want the appropriate authorization (either granted from the schema's owner or by using the DBA role) or want to use 'CONNECT'

Docs are also available from http://otn.oracle.com - where you probably downloaded the software, or from the documentation CD which you would have received in case you happen to have purchased the software licenses.

/Hans

Igor Damiani wrote:

> Hello everybody....
>
> Using MS-SQL Server I can write this simple T-SQL command:
>
> use "db_name"
>
> Can I obtain same result using Oracle 8.1 database server?
> I need to login with unique username and password, and change different
> database using SQL command
> to run ALTER TABLE and other SQL script......
>
> Can you help me, please?
> Tks a lot!!!
> good coding!!!
> --
> Damiani Liborio Igor
> http://www.igordamiani.it
> Nella finestra Debug di VB:
> Nome="igor":? Nome & Chr$(64) & Nome & "damiani" & Chr$(46) & "it"
> Che tu sia maledetto, SWEN...

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]