Set schema="yourdb" 
Author Message
 Set schema="yourdb"

OK, there's no such command.  Or is there?  SQLServer has
a "use" command that does the equivalent, ... or am I
thinking of DBase III?

I guess the approved approach in Oracle is to use roles, right?

Josh



Mon, 02 Oct 2000 03:00:00 GMT
 Set schema="yourdb"

alter session set current_schema = <your schema>;



Quote:
> OK, there's no such command.  Or is there?  SQLServer has
> a "use" command that does the equivalent, ... or am I
> thinking of DBase III?

> I guess the approved approach in Oracle is to use roles, right?

> Josh



Mon, 02 Oct 2000 03:00:00 GMT
 Set schema="yourdb"

Thanks!

Unbelievable how hard it seems, to get this kind of basic stuff out of
the Oracle docs and even relatively experienced users.

Josh



Quote:
>alter session set current_schema = <your schema>;



>> OK, there's no such command.  Or is there?  SQLServer has
>> a "use" command that does the equivalent, ... or am I
>> thinking of DBase III?

>> I guess the approved approach in Oracle is to use roles, right?

>> Josh



Mon, 02 Oct 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Set schema="yourdb"

2. "set current schema" and commit

3. max of ("...","...","..")

4. Extracting "Column Description" from schema

5. "Optimize Cube Schema" via script

6. Optimal Schema Design - "Enumerated Typed Fields"

7. "Schema"-equivalent in SQL Server

8. DTS with "dynamic" source schema

9. Todo "claim": psql tab completion on schema names

10. Privileges on "demo" schema

11. Defination of "SCHEMA"

12. "schema"


 
Powered by phpBB® Forum Software