Parameter and keyword description - %type attribute, PL-SQL Programming

Parameter and Keyword Description:

collection_name:

This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope.

cursor_variable_name:

This keyword a PL/SQL cursor variable formerly declared within the present scope. Only the value of the other cursor variable can be assigned to the cursor variable.

object_name:

This keyword identifies an object (instance of the object type) formerly declared within the present scope.

record_name:

This keyword identifies a user-defined or %ROWTYPE record formerly declared within the present scope.

record_name.field_name:

This keyword identifies the field in a user-defined or %ROWTYPE record formerly declared within the present scope.

table_name.column_name:

This refers to the table and column that should be accessible when the declaration is explained.

variable_name:

This keyword identifies a variable formerly declared in similar scope.

Posted Date: 10/8/2012 8:09:45 AM | Location : United States







Related Discussions:- Parameter and keyword description - %type attribute, Assignment Help, Ask Question on Parameter and keyword description - %type attribute, Get Answer, Expert's Help, Parameter and keyword description - %type attribute Discussions

Write discussion on Parameter and keyword description - %type attribute
Your posts are moderated
Related Questions
Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

Change Sql file into CSV for product registration on Magento Project Description: I have a set of files that are in Sql format and could like for a developer to help me with

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

query to Find the account numbers of all customers whose balance is more than 10,000 $

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

How Exceptions Are Raised By the run-time system, the internal exceptions are raised implicitly as are user-defined exceptions that you have related with an Oracle error number