Interested to Buy Any Domain ? << Click Here >> for more details...
You have just compiled a PL/SQL package but got errors, how
would you view the errors?
- 3 Answers
- 9498 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh
show error package <package name>
to check the compilation errors
similarly for functions
show error function <function name>
and for procedures
show error procedure <procedure name>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the commands you'd issue to show the explain plan for "select * from dual"?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can you implement fine-grained auditing?
What is transparent data encryption? : sql server DBA
Why would you call update statistics? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the commands used in dcl? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what are the types of connection load-balancing?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what are the benefits of flashback feature?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
