Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

PL/SQL

Index PL/SQL

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. [1]

55 relations: Ada (programming language), Adaptive Server Enterprise, Array data type, Assignment (computer science), Associative array, Berkeley DB, C++, Concurrency control, Conditional (computer programming), Control flow, Cursor (databases), Data definition language, Data manipulation language, Data type, Database trigger, Delphi (IDE), Evaluation strategy, Exception handling, For loop, Free Pascal, IBM Db2, Iteration, Java (programming language), Lock (computer science), Method (computer programming), Microsoft, Microsoft SQL Server, Modular programming, Null (SQL), O'Reilly Media, Object Pascal, Object-oriented programming, Object-PL/SQL, Oracle Call Interface, Oracle Corporation, Oracle Database, Pascal (programming language), PL/pgSQL, PostgreSQL, Procedural programming, Programming language, Relational database, Relational database management system, Reserved word, SQL, SQL PL, SQL/PSM, SQLite, Stored procedure, Subroutine, ..., Sybase, TimesTen, Transact-SQL, Variable (computer science), While loop. Expand index (5 more) »

Ada (programming language)

Ada is a structured, statically typed, imperative, and object-oriented high-level computer programming language, extended from Pascal and other languages.

New!!: PL/SQL and Ada (programming language) · See more »

Adaptive Server Enterprise

SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server product for businesses developed by Sybase Corporation which became part of SAP AG.

New!!: PL/SQL and Adaptive Server Enterprise · See more »

Array data type

Language support for array types may include certain built-in array data types, some syntactic constructions (array type constructors) that the programmer may use to define such types and declare array variables, and special notation for indexing array elements.

New!!: PL/SQL and Array data type · See more »

Assignment (computer science)

In computer programming, an assignment statement sets and/or re-sets the value stored in the storage location(s) denoted by a variable name; in other words, it copies a value into the variable.

New!!: PL/SQL and Assignment (computer science) · See more »

Associative array

In computer science, an associative array, map, symbol table, or dictionary is an abstract data type composed of a collection of (key, value) pairs, such that each possible key appears at most once in the collection.

New!!: PL/SQL and Associative array · See more »

Berkeley DB

Berkeley DB (BDB) is a software library intended to provide a high-performance embedded database for key/value data.

New!!: PL/SQL and Berkeley DB · See more »

C++

C++ ("see plus plus") is a general-purpose programming language.

New!!: PL/SQL and C++ · See more »

Concurrency control

In information technology and computer science, especially in the fields of computer programming, operating systems, multiprocessors, and databases, concurrency control ensures that correct results for concurrent operations are generated, while getting those results as quickly as possible.

New!!: PL/SQL and Concurrency control · See more »

Conditional (computer programming)

In computer science, conditional statements, conditional expressions and conditional constructs are features of a programming language, which perform different computations or actions depending on whether a programmer-specified boolean condition evaluates to true or false.

New!!: PL/SQL and Conditional (computer programming) · See more »

Control flow

In computer science, control flow (or flow of control) is the order in which individual statements, instructions or function calls of an imperative program are executed or evaluated.

New!!: PL/SQL and Control flow · See more »

Cursor (databases)

In computer science, a database cursor is a control structure that enables traversal over the records in a database.

New!!: PL/SQL and Cursor (databases) · See more »

Data definition language

A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.

New!!: PL/SQL and Data definition language · See more »

Data manipulation language

A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.

New!!: PL/SQL and Data manipulation language · See more »

Data type

In computer science and computer programming, a data type or simply type is a classification of data which tells the compiler or interpreter how the programmer intends to use the data.

New!!: PL/SQL and Data type · See more »

Database trigger

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.

New!!: PL/SQL and Database trigger · See more »

Delphi (IDE)

Delphi is an integrated development environment (IDE) for rapid application development of desktop, mobile, web, and console software, developed by Embarcadero Technologies.

New!!: PL/SQL and Delphi (IDE) · See more »

Evaluation strategy

Evaluation strategies are used by programming languages to determine when to evaluate the argument(s) of a function call (for function, also read: operation, method, or relation) and what kind of value to pass to the function.

New!!: PL/SQL and Evaluation strategy · See more »

Exception handling

Exception handling is the process of responding to the occurrence, during computation, of exceptions – anomalous or exceptional conditions requiring special processing – often changing the normal flow of program execution.

New!!: PL/SQL and Exception handling · See more »

For loop

In computer science, a for-loop (or simply for loop) is a control flow statement for specifying iteration, which allows code to be executed repeatedly.

New!!: PL/SQL and For loop · See more »

Free Pascal

Free Pascal Compiler (FPC) is a compiler for the closely related programming language dialects, Pascal and Object Pascal.

New!!: PL/SQL and Free Pascal · See more »

IBM Db2

IBM Db2 contains database-server products developed by IBM.

New!!: PL/SQL and IBM Db2 · See more »

Iteration

Iteration is the act of repeating a process, to generate a (possibly unbounded) sequence of outcomes, with the aim of approaching a desired goal, target or result.

New!!: PL/SQL and Iteration · See more »

Java (programming language)

Java is a general-purpose computer-programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible.

New!!: PL/SQL and Java (programming language) · See more »

Lock (computer science)

In computer science, a lock or mutex (from mutual exclusion) is a synchronization mechanism for enforcing limits on access to a resource in an environment where there are many threads of execution.

New!!: PL/SQL and Lock (computer science) · See more »

Method (computer programming)

A method in object-oriented programming (OOP) is a procedure associated with a message and an object.

New!!: PL/SQL and Method (computer programming) · See more »

Microsoft

Microsoft Corporation (abbreviated as MS) is an American multinational technology company with headquarters in Redmond, Washington.

New!!: PL/SQL and Microsoft · See more »

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

New!!: PL/SQL and Microsoft SQL Server · See more »

Modular programming

Modular programming is a software design technique that emphasizes separating the functionality of a programme into independent, interchangeable modules, such that each contains everything necessary to execute only one aspect of the desired functionality.

New!!: PL/SQL and Modular programming · See more »

Null (SQL)

Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database.

New!!: PL/SQL and Null (SQL) · See more »

O'Reilly Media

O'Reilly Media (formerly O'Reilly & Associates) is an American media company established by Tim O'Reilly that publishes books and Web sites and produces conferences on computer technology topics.

New!!: PL/SQL and O'Reilly Media · See more »

Object Pascal

Object Pascal refers to a branch of object-oriented derivatives of Pascal, mostly known as the primary programming language of Delphi.

New!!: PL/SQL and Object Pascal · See more »

Object-oriented programming

Object-oriented programming (OOP) is a programming paradigm based on the concept of "objects", which may contain data, in the form of fields, often known as attributes; and code, in the form of procedures, often known as methods. A feature of objects is that an object's procedures can access and often modify the data fields of the object with which they are associated (objects have a notion of "this" or "self").

New!!: PL/SQL and Object-oriented programming · See more »

Object-PL/SQL

Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database.

New!!: PL/SQL and Object-PL/SQL · See more »

Oracle Call Interface

In computing, the Oracle Call Interface (OCI) consists of a set of C-language software APIs which provide an interface to the Oracle database.

New!!: PL/SQL and Oracle Call Interface · See more »

Oracle Corporation

Oracle Corporation is an American multinational computer technology corporation, headquartered in Redwood Shores, California.

New!!: PL/SQL and Oracle Corporation · See more »

Oracle Database

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

New!!: PL/SQL and Oracle Database · See more »

Pascal (programming language)

Pascal is an imperative and procedural programming language, which Niklaus Wirth designed in 1968–69 and published in 1970, as a small, efficient language intended to encourage good programming practices using structured programming and data structuring. It is named in honor of the French mathematician, philosopher and physicist Blaise Pascal. Pascal was developed on the pattern of the ALGOL 60 language. Wirth had already developed several improvements to this language as part of the ALGOL X proposals, but these were not accepted and Pascal was developed separately and released in 1970. A derivative known as Object Pascal designed for object-oriented programming was developed in 1985; this was used by Apple Computer and Borland in the late 1980s and later developed into Delphi on the Microsoft Windows platform. Extensions to the Pascal concepts led to the Pascal-like languages Modula-2 and Oberon.

New!!: PL/SQL and Pascal (programming language) · See more »

PL/pgSQL

PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS.

New!!: PL/SQL and PL/pgSQL · See more »

PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

New!!: PL/SQL and PostgreSQL · See more »

Procedural programming

Procedural programming is a programming paradigm, derived from structured programming, based upon the concept of the procedure call.

New!!: PL/SQL and Procedural programming · See more »

Programming language

A programming language is a formal language that specifies a set of instructions that can be used to produce various kinds of output.

New!!: PL/SQL and Programming language · See more »

Relational database

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.

New!!: PL/SQL and Relational database · See more »

Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

New!!: PL/SQL and Relational database management system · See more »

Reserved word

In a computer language, a reserved word (also known as a reserved identifier) is a word that cannot be used as an identifier, such as the name of a variable, function, or label – it is "reserved from use".

New!!: PL/SQL and Reserved word · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: PL/SQL and SQL · See more »

SQL PL

SQL PL stands for Structured Query Language Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 (DB2 UDB Version 7) database system.

New!!: PL/SQL and SQL PL · See more »

SQL/PSM

SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

New!!: PL/SQL and SQL/PSM · See more »

SQLite

SQLite is a relational database management system contained in a C programming library.

New!!: PL/SQL and SQLite · See more »

Stored procedure

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS).

New!!: PL/SQL and Stored procedure · See more »

Subroutine

In computer programming, a subroutine is a sequence of program instructions that performs a specific task, packaged as a unit.

New!!: PL/SQL and Subroutine · See more »

Sybase

Sybase was an enterprise software and services company that produced software to manage and analyze information in relational databases.

New!!: PL/SQL and Sybase · See more »

TimesTen

TimesTen is an in-memory, relational database management system with persistence and recoverability.

New!!: PL/SQL and TimesTen · See more »

Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.

New!!: PL/SQL and Transact-SQL · See more »

Variable (computer science)

In computer programming, a variable or scalar is a storage location (identified by a memory address) paired with an associated symbolic name (an identifier), which contains some known or unknown quantity of information referred to as a value.

New!!: PL/SQL and Variable (computer science) · See more »

While loop

In most computer programming languages, a while loop is a control flow statement that allows code to be executed repeatedly based on a given Boolean condition.

New!!: PL/SQL and While loop · See more »

Redirects here:

P/SQL, PL SQL, PLSQL, StepSqlite.

References

[1] https://en.wikipedia.org/wiki/PL/SQL

OutgoingIncoming
Hey! We are on Facebook now! »