Description : What is the basic structure of PL/SQL ?
Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.
Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?
Last Answer : SHOW ERRORS
Description : What command would you use to encrypt a PL/SQL application?
Last Answer : WRAP
Description : How you were passing cursor variables in PL/SQL 2.2?
Last Answer : In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.
Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.
Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Last Answer : Procedures and Functions,Packages and Database Triggers.
Description : What are the cursor attributes used in PL/SQL ?
Last Answer : %ISOPEN - to check whether cursor is open or not % ROWCOUNT - number of rows fetched/updated/deleted. % FOUND - to check whether cursor has fetched any row. True if rows are ... featched. These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.
Description : What are the components of a PL/SQL block ?
Last Answer : A set of related declarations and procedural statements is called block.
Description : What are the components of a PL/SQL Block ?
Last Answer : Declarative part, Executable part and Exception part.Datatypes PL/SQL
Description : What are the PL/SQL Statements used in cursor processing ?
Last Answer : DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.
Description : Explain how procedures and functions are called in a PL/SQL block ?
Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');
Description : Question What is PL/SQL ?
Last Answer : PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching.
Description : What are the two panes that Appear in the design time pl/sql interpreter?
Last Answer : 1. Source pane. 2. Interpreter pane
Description : What are three panes that appear in the run time pl/sql interpreter?
Last Answer : 1. Source pane. 2. interpreter pane. 3. Navigator pane.
Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?
Last Answer : At the client.
Description : Does PL/SQL support “overloading”? Explain
Last Answer : The concept of overloading in PL/SQL relates to the idea that you can define procedures and functions with the same name. PL/SQL does not look only at the referenced name, however, ... Prefacing a procedure or function name with the package name fully qualifies any procedure or function reference.
Description : what are the datatypes supported By oracle (INTERNAL)?
Last Answer : Varchar2, Number,Char , MLSLABEL.
Description : What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
Last Answer : % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in ... database definition of a column in a table changes, the data type of a variable changes accordingly.
Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?
Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?
Description : Does anyone here have experience working with PL/SQL? I need some help getting started...
Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.
Description : Python has a SQL-like querylanguage called ________- a) GQLb) PL SQL c) NOSQL d) JDBC
Last Answer : GQL
Description : What is the significance of the & and && operators in PL SQL ?
Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).
Description : Can you have two functions with the same name in a PL/SQL block
Last Answer : Yes.
Description : Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel
Last Answer : PL/SQL
Description : What are the types of SQL Statement ?
Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.
Description : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA
Last Answer : Execute the "ORADEBUG HELP" command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug ... oradebug lkdebug -a convres SQLPLUS> oradebug lkdebug -r (i.e 0x8066d338 from convres dump)
Description : What is the difference between the SQL*Loader and IMPORT utilities?
Last Answer : These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL* ... from different data sources just so long as it conforms to ASCII formatted or delimited files.
Description : Is it possible to insert comments into sql statements return in the data model editor?
Last Answer : Yes
Description : Can you use select in FROM clause of SQL select ?
Description : How many types of Sql Statements are there in Oracle
Last Answer : There are basically 6 types of sql statments.They are a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects. b) Data Manipulation Language(DML) :: The DML ... e.g:: Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close
Description : maxvalue.sql Select the Nth Highest value from a table?
Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level
Description : What are various constraints used in SQL?
Last Answer : NULL -NOT NULL -CHECK -DEFAULT
Description : minvalue.sql Select the Nth lowest value from a table?
Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level
Description : What is difference between SQL and SQL*PLUS?
Last Answer : SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle ... SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.
Description : What package procedure used for invoke sql *plus from sql *forms ?
Last Answer : Host (E.g. Host (sqlplus))
Description : What is an SQL *FORMS ?
Last Answer : SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
Description : What are the factors causing the reparsing of SQL statements in SGA?
Last Answer : Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE. LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE.
Description : What is a Shared SQL pool?
Last Answer : The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users.
Description : What are the sql clauses supported in the link property sheet?
Last Answer : Where start with having.
Last Answer : Due to insufficient shared pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.
Description : What is a SQL * NET?
Last Answer : SQL *NET is ORACLE's mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed databases. It is used in Clint- Server and Server-Server communications.
Description : Define SQL and state the differences between SQL and other conventional programming Languages
Last Answer : SQL is a nonprocedural language that is designed specifically for data access operations on normalized relational database structures. The primary difference between SQL and other conventional programming ... specify what data operations should be performed rather than how to perform them.
Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?
Last Answer : The table has a BLOB column.
Description : Name three clients to connect with Oracle, for example, SQL Developer:
Last Answer : SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL Developer… There are several, but an experienced dba should know at least three clients.
Description : What are the default values of the primitive datatypes int and float?
Last Answer : Ans. The default value of int is 0 and the default value of float is 0.0f.
Description : what are the datatypes supported By oracle (INTERNAL)
Description : What strategies are available for backing-up an Oracle database? (for DBA
Last Answer : The following methods are valid for backing-up an Oracle database: Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. ... , etc. If your database is in ARCGIVELOG mode, you also need to backup archived log files.
Description : What are two virtual tables available during database trigger execution ?
Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.
Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr
Description : What are the design facilities available in forms 4.0?
Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.