Forums
Wordpress
Wordpress Themes
Oracle Switching to...
 
Notifications
Clear all

Oracle Switching to a Different Schema  

    Last Post
   RSS

1
03/05/2020 5:28 pm

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

chapr89
chapr89 
(@chapr89)
Eminent Member
| 21 Posts
20 3 0
Add a comment
1 Answer
1
03/05/2020 5:31 pm
ALTER SESSION SET CURRENT_SCHEMA = <schema name>;

example:
ALTER SESSION SET CURRENT_SCHEMA = EmployeeDB;
chapr89
chapr89 
(@chapr89)
Eminent Member
| 21 Posts
20 3 0
Add a comment
  All forum topics
  Previous Topic
Share:
Share this
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •