Oracle Switching to a Different Schema

Last Post

RSS

03/05/2020 5:28 pm

How to switch to a different schema in Oracle - SQL Developer?

chapr89

(@chapr89)

Eminent Member

| 21 Posts
20 3 0

Add a comment

1 Answer

03/05/2020 5:31 pm

ALTER SESSION SET CURRENT_SCHEMA = <schema name>;

example:
ALTER SESSION SET CURRENT_SCHEMA = EmployeeDB;

chapr89

(@chapr89)

Eminent Member

| 21 Posts
20 3 0

Add a comment

Forum Statistics

67 Forums

73 Topics

94 Posts

6 Online

18.7 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed