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

Declaring cursor variables, Declaring Cursor Variables Once a REF CURS...

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

Write a pl/sql anonymous block that accepts an employee id, Based on the EM...

Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

Sql database, SQL Database: So, an SQL database is one whose symbols a...

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

Using prior and next - collection method, Using PRIOR and NEXT The PRI...

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

Understanding nested tables, Understanding Nested Tables Within the data...

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

Sql queries-oracle , 1- You can check attribute names from each table in D...

1- You can check attribute names from each table in DBF11 by running for example:  desc dbf11.Member;  desc dbf11.Agent;  desc dbf11.Producer; Because some attribute names in

Autonomous versus nested transactions, Autonomous versus Nested Transaction...

Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)

Running the pl/sql wrapper, Running the PL/SQL Wrapper To run the PL/SQ...

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Keyword and parameter description in pl sql, Keyword and Parameter Descript...

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Cursors, What is Cursors how to use it in Real time application ?

What is Cursors how to use it in Real time application ?

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