You have just compiled a PL/SQL package but got errors, how
would you view the errors?
Answer Posted / santo
Sometimes 'Show error' won't display the required
info...then check dba_errors table
select text from dba_errors where name='****';
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what are the benefits of flashback feature?
how can you get actual data change values from previous transactions in oracle?
who owns the operating system files created by the utl_file package?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the diffrence between core dba and apps dba?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is dbcc? : sql server DBA
Can you redefine a table online?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
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.
what are the types of connection load-balancing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?