Components of an object type in pl/sql, PL-SQL Programming

Assignment Help:

Components of an Object Type:

An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but not exceptions, constants, cursors, or types. You should declare at least one attribute (the highest is 1000); methods are optional. You cannot add the attributes to an existing object type (i.e., the type evolution is not supported).

Related Discussions:- Components of an object type in pl/sql

Obtaining a natural join by specifying the common columns, Obtaining a natu...

Obtaining a natural join by specifying the common columns Synatax: SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON USING ( StudentId ) However, a named columns join doe

Sql cursor - syntax, SQL Cursor The Oracle implicitly opens a cursor...

SQL Cursor The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Introduction to SQl and DQL, which operation is used if we are interested i...

which operation is used if we are interested in only certain columns of a table?

Biochemical origin of life - modern concept, BIOCHE M ICA L ORIGIN OF LI...

BIOCHE M ICA L ORIGIN OF LIFE - It is generally agreed by astronomers, geologists and biologists that the earth is approximately 4500-5000 million years old. It is an

Cursor variables in pl sql, Cursor Variables: To execute the multi-...

Cursor Variables: To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

Sql operators, SQL Operators The PL/SQL uses all the SQL set, compariso...

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators. 1. Comparison Opera

Full time system administrator, Need Windows and Linux system Administrator...

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

Iterative control:exit statements, EXIT The EXIT statement forces a loop...

EXIT The EXIT statement forces a loop to done unconditionally. Whenever an EXIT statement is encountered, the loop is done immediately and controls the passes to the next statem

Update statement - syntax, UPDATE Statement The UPDATE statement tra...

UPDATE Statement The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Keyword, what is the use of declare keyword

what is the use of declare keyword

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages