Role of abstraction in pl/sql, PL-SQL Programming

Assignment Help:

Role of Abstraction in pl/sql:

The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us cause about an object, event, or relationship by suppressing the irrelevant detail. For illustration, to drive a car, you do not require to know how its engine works. The simple interface consisting of a steering wheel, gearshift, accelerator, and brake, lets you use the car efficiently. The details of what happens under the hood are not significant for day-to-day driving.

The Abstractions are central to the discipline of programming. For illustration, you use the procedural abstraction when you suppress the details of a complex algorithm by writing a procedure and passing it parameters. A single procedure call hides the particulars of your implementation. To try a special implementation, you simply replace the procedure with the other having similar name and parameters. Thanks to the abstraction, programs that call the procedure need not be customized.

You use the data abstraction when you state the datatype of the variable. The datatype stipulate a set of values and a set of operations suitable for those values. For illustration, a variable of the type POSITIVE can hold only the positive integers, and can only be added, multiplied, and subtracted, and so on. To use the variable, you do not require knowing how the PL/SQL stores integers or implements arithmetic operations; you basically accept the programming interface.

The Object types are a generalization of the built-in datatypes found in many programming languages. The PL/SQL gives a variety of the built-in scalar and composite datatypes, each of that is associated with the set of predefined operations. The scalar type (like CHAR) has no internal components. The composite type (like the RECORD) has internal components which can be manipulated separately. Similarly the RECORD type, an object type is a composite type. Though, its operations are user-defined, and not predefined.

Presently, you cannot define object types within the PL/SQL. They should be CREATED and stored in an Oracle database, where they can be shared by a lot of programs. A program which uses the object types is known as the client program. It can manipulate and declare an object without knowing how the object type presents data or implements operations. This permits you to write the program and object type individually, and to change the implementation of the object type without affecting the program. And hence, the object types support both the procedural and data abstraction.


Related Discussions:- Role of abstraction in pl/sql

Parameter and keyword description - procedures, Parameter and Keyword Descr...

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

Parameter and keyword description - sql cursor, Parameter and Keyword Descr...

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

Positional and named notation, Positional and Named Notation You can wr...

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

Join query, Using a join on 3 tables, select 5 columns and 10 rows from the...

Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN

I need sql to infopath data connection, I need SQL to infopath data connect...

I need SQL to infopath data connection Project Description: Want data retrieval connection from SQL to SharePoint infopath Skills required are Sharepoint, SQL

Effect of anonymous columns, Effect of Anonymous Columns Now, recall t...

Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

Closing a cursor - explicit cursor, Closing a Cursor The CLOSE stateme...

Closing a Cursor The CLOSE statements disable the cursor, and the result set becomes undefined. An illustration of the CLOSE statement as shown: CLOSE c1;

Write a stored procedure, a. Create a table odetails_new. It has all the a...

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Organic evolution, Organi c Evolution Evolution is a slow continuou...

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie

Pragma restrict_references in pl sql, Using Pragma RESTRICT_REFERENCES: ...

Using Pragma RESTRICT_REFERENCES: The function called from the SQL statements should obey certain rules meant to control the side effects. To check for violation of the rules,

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd