Computer Certification

Recent Answers

2012-05-22 Oracle - PL SQL:

The data in temporary tables will be available till session expires (ON COMMIT PRESERVE ROWS) or commit is issued (ON COMMIT DELETE ROWS).    The data in a global temporary table is private, such that

2012-05-18 Peoplesoft - NA Payroll - GL interface:

Hi Chetan,    Hope you are doing great! The subject is elaborate and difficult to explain in a single page but let me give you a few pointers which should help.     Lets start with the reports. The most

2012-05-11 Oracle - regd backup:

Hello Seshu,    The best way is to take backup of your schema (user) using export utility, create new schema and import the backup in this schema. Then you can make changes in your current schema and compare

2012-05-09 Oracle - Oralce Interview Qs:

Good morning Gaurav,    The answer to your questions is: it depends.    1. "Replacing" I take it to mean to restore a database from a "backup". If you are doing a point-in-time, chances are you would have

2012-05-08 Oracle - Oracle DB - Constraint Tables:

Hi Wilfred,    The USER_CONSTRAINTS and USER_CONS_COLUMNS will only show the data that relates the owner of the objects. If those objects were created by anoter owner (or schema), then you will need to