You have just compiled a PL/SQL package but got errors, how
would you view the errors?
Answer Posted / priya reddy
show error;
This is the command used to view the errors..
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different sql server versions you have worked on? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What are the commands used in dcl? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Why would you call update statistics? : sql server DBA
Can you redefine a table online?
what are the differences of where and if in SAS?
Which autogrowth database setting is good? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What the different components in replication and what is their use? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
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
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
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 is a crs resource?