OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » schema

Tue, 30 April 2002 10:03

Su
Messages: 154
Registered: April 2002

Senior Member

how to set schema.

alter session set schema = ABC
is this right

thanks
su

Wed, 01 May 2002 04:43

John R
Messages: 156
Registered: March 2000

Senior Member

Nope.

Your schema is defined by the user id that you log in as.

Wed, 01 May 2002 10:03

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

alter session set current_schema = ABC;

Previous Topic:	how can i get recursive values thru query
Next Topic:	Why won't my date stay when I create a new record

Goto Forum:

]

Current Time: Thu Apr 25 19:57:37 CDT 2024