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

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).

 

 

Posted Date: 10/6/2012 8:00:46 AM | Location : United States







Related Discussions:- Components of an object type in pl/sql, Assignment Help, Ask Question on Components of an object type in pl/sql, Get Answer, Expert's Help, Components of an object type in pl/sql Discussions

Write discussion on Components of an object type in pl/sql
Your posts are moderated
Related Questions
Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.

Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot

Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche