User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
Change Current Schema
Sun, 07/06/2008 - 1:57pm — Lepa
And voila, table was found.
A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes. To access tables not on your schema, you need to issue the "Schema Alter" command.
Lets go through an example and try to access a table in the HR schema from a different schema and see what happens.
Now, lets alter our schema session and try again.
ALTER session
SET current_schema = HR;
SELECT * FROM employees;
SET current_schema = HR;
SELECT * FROM employees;
And voila, table was found.
Bookmark/Search this post with
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
About Lepa
Job title
Application Developer
Poll
New forum topics
- MD5 - SHA checksum of a file.
- nVision Tabular Report through PIA with prompts
- Enable/Install GP and T&L modules on existing HRMS System
- How to get the list of tables having specific field as key.
- How to populate data into grid, click on pushbutton
- peoplesoft
- Can we create an AE to mass update Position - Jobcode data?
- How to do the Upgradation from one version to another version
Recent comments
- SQL to Show Database Information
19 hours 51 min ago - Re: Component Permission List Query
1 week 11 hours ago - Re: How to populate data into grid, click on pushbutton
1 week 19 hours ago - Re: Arrays in PeopleSoft
1 week 2 days ago - Re: I want to add a hyperlink to a peoplesoft delivered ...
1 week 2 days ago - Re: How to get the list of tables having specific field as key.
1 week 2 days ago - Re: I want to add a hyperlink to a peoplesoft delivered ...
1 week 6 days ago - Re: inserting rows within standalone rowset without fill
2 weeks 8 hours ago - Re: How to populate data into grid, click on pushbutton
2 weeks 9 hours ago - Re: Name change Workflow using PS role query
2 weeks 1 day ago
Comments
Thanks Compshack!!! What is the difference between database and schema? Can Database contains any number of schemas?
At my client place we have production, Test and Dev databases. does these are databases are schemas? How can we identify weather it is a schema or database?
It's nice to know this command and it comes in handy a lot of times.
But, you do not want to be switching schemas all the time. Typically the owner schema will grant the other users/schema select previliges; only the users that are allowed to see that data.
This way you can access that data from the schema you are currently logged into without having to switch back and forth.
I can answer the difference between a database and a schema.
The database is a collection of many objects. For example Your company would be a database, and all the employess are the users/schemas. You can have as many users/schemas as you want in a database.
Each user would own different objects and have privilges and access to objects other users can't have.
To answer your question about whether the DEV, Test and production are different databases, they should be. And usually under all these 3 databases you will have the same users, because they should be similar to each other. If Dev, Test and production are 3 users under one database instance, then this a really bad desgin in my opinion.
Post new comment