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
- 9469 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
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 the different topologies in which replication can be configured? : sql server DBA
what is the role of dip user in our database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Why would you use sql agent? : sql server DBA
what is the diffrence between core dba and apps dba?
what are the differences of where and if in SAS?
Query processing is slow(eg select query)how will u solve that
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?
What the different types of replication and why are they used? : sql server DBA
what is a crs resource?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different components in replication and what is their use? : sql server DBA
how can you initialize log miner?
