How to debug the procedure or function? By using DBMS_OUTPUT & DBMS_DEBUG oracle supplied package. ALTER PROCEDURE procedurename DEBUG; OR ALTER PROCEDURE procedurename PLSQL_DEBUG=TRUE OR We can use autonomous_transaction procedure to create log & put...
The general syntax is: FIRST_VALUE(
What are the advantage & disadvantage of package A package is a group of PL/SQL types, objects, and stored procedures and functions. The specification part of a package declares the public types, variables, constants, and subprograms that are visible...
DROP PACKAGE [BODY] The DROP PACKAGE statement removes a stored package from the database. Both the specification and the body are dropped. DROP PACKAGE BODY removes only the body of the package. Required privilege No privilege is required for the package...
1. How to invoke the Functions in SQL Expressions? We invoke the SQL functions when activates are too complex, too awkward, or unavailable with SQL. By invoking functions we can increase efficiency when used in the WHERE clause to filter data, as opposed...
1. What are the restrictions on calling Functions from SQL Expressions? To be callable from SQL expressions, a user-defined PL/SQL function must meet certain requirements. • Parameters to a PL/SQL function called from a SQL statement must use positional...
Module Overloading Two or more modules can, under certain conditions, have the same name with different parameter lists. Such modules are said to be overloaded. The code in these overloaded programs can be very similar or can be completely different....
SSIS 1: What is SSIS? How it is related with SQL Server. SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server....
The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track...
How to launch 5 diff application from 5 child process What is the use of man command? Print numbers in the reverse order How to write program to print descending order What is the method by which we find the list of users logged on a server using telnet...
