Primary sources date November 2009 Notability date November 2009 SQLPL stands for SQL 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. ref http publib.boulder.ibm.com infocenter db2luw v9 index.jsp?topic com.ibm.db2.udb.apdv.sql.doc doc c0011916.htm IBM Info Center ref It provides procedural programming procedural programmability in addition to the querying commands of SQL. References references External links http www.sqlpl guide.com SQLPL Guide for developing Stored Procedures in DB2 DEFAULTSORT SqlPl Category SQL Category IBM software compu soft stub ... more details
PLSQL Procedural Language Structured Query Language is Oracle Corporation s Procedural programming procedural ... database . PLSQL s general Syntax programming languages syntax resembles that of Ada programming language Ada . PLSQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java programming language Java . PLSQL is available in Oracle Database since version ... Introduction PLSQL supports variable programming variable s, Conditional programming condition s, program ..., though in a somewhat unusual way, involving the use of PLSQL collections. PLSQL collections are a slightly ... associated with Object oriented programming object orientation . PLSQL program units essentially code containers can be compiled into the Oracle database. Programmers can thus embed PLSQL units of functionality into the database directly. They also can write scripts containing PLSQL program ... can readily embed Data Manipulation Language DML statements directly into their PLSQL code using ... to be written in the PLSQL code. However, DML statements underpin the majority of PLSQL code in typical software applications. In the case of PLSQL dynamic SQL, early versions of the Oracle ... release of the Oracle Database. PLSQL program units Anonymous blocks http download.oracle.com ... PLSQL code, and have the following structure source lang PLSQL label DECLARE Type item function ... datatype s in PLSQL include NUMBER, INTEGER, CHAR, VARCHAR2, DATE, TIMESTAMP, TEXT etc. Functions Functions in PLSQL group together SQL and PLSQL statements that perform a task and should return ... in PLSQL. The traditional function has the form source lang PLSQL CREATE OR REPLACE FUNCTION function ... block BEGIN PLSQL block with return statement RETURN return value Exception exception block ... Arup last1 Nanda author1 link first2 Steven last2 Feuerstein author2 link title Oracle PLSQL for DBAs ... CURRENT USER DEFINER AGGREGATE PIPELINED IS USING declaration block BEGIN PLSQL block with return statement ... more details
saved book title Oracle PLSQL subtitle cover image cover color sort as PlSql Oracle PLSQL Oracle Database SQLPLSQL Data Definition Language Data Manipulation Language Data Control Language Database Table database Table Insert SQL Insert Unique key Select SQL Select Update SQL Update Delete SQL Delete Where SQL Where Null SQL Null Order by ... more details
Pl , an anthocyanidin Airstars Airways , IATA airline designators PL AeroPeru , IATA airline designators PL Ice pellets , METAR Code PL Digital Private Line Two variants of litre , picolitre pL and petaliter PL In computing and internet tt .pl tt , country code top level domain for Poland tt .pl tt , common filename suffix for Perl scripts tt .pl tt , common filename suffix for Prolog programs tt .pl tt , common filename suffix for TeX font metric TeX font property lists PL C PL I PLSQL Packet ...Letter NumberCombination PK PM OL QL wiktionarypar plPlPLPL , P.L. , Pl , or Pl. can refer to In politics, law and philosophy Pl., an abbreviation for Plural Partido Laborista disambiguation Partido Laborista Patrologia Latina Philippine Legislature , a legislature that existed in the Philippines from 1907 to 1935 PL Kyodan , a religious movement founded in Japan in the early 20th Century Poland Polish language Progressive Labor Party United States Progressive Labor Party , a United States communist party Propositional logic , a system of evaluating truth based propositions in terms of binary logic Public library Private Limited , a term that is used in India for a company that is privately held. Public law Public liability PL, the postal district for Plymouth , West Devon , and Cornwall east of Bodmin and south of Bude An abbreviation for Proprietary limited company in Australia In science, aviation and military PL tone Patriotic League Bosnian Patriotska Liga , a first military organisation of Republic of Bosnia and Herzegovina Photoluminescence Piecewise linear Pierre Levasseur aircraft builder Pierre Levasseur , a French aircraft designer Platoon Leader in the United States Army ... logistics provider In Broadcasting Private Line intercom disambig ca PL cs PL da PL de PL el PL es PL eo Pl fa PL fr PL ko PL it PL sw PL lv PL lt PL nl Pl ja PL no Pl pt PL sl PL fi Pl sv PL th uk PL ... more details
center IBM align center SQLPLSQL Procedural Language implements SQL PSM align center Microsoft ... Stored Module implements SQL PSM align center Oracle Corporation Oracle align center PLSQL Procedural Language SQL based on Ada programming language Ada align center PostgreSQL align center PL pgSQL Procedural Language PostgreSQL Structured Query Language based on Oracle PLSQL align center PostgreSQL align center PL PSM Procedural Language Persistent Stored Modules implements SQL PSM In addition ... Query Language nn SQL mhr SQLplSQL pt SQL ro SQL ru SQL sq SQL simple Structured Query ...About the database language the specific Microsoft database server SQL Server the airport with IATA code SQL San Carlos Airport Infobox programming language name SQL paradigm Multi paradigm programming ... release version SQL 2008 latest release date 2008 turing complete No typing Static typing Static ... SQL 86, SQL 89, SQL 92 , SQL 1999 , SQL 2003 , SQL 2008 influenced by Datalog influenced Agena programming ... Database languages SQL Part 1 Framework SQL Framework file ext .sql Infobox file format name SQL screenshot caption Structured Query Language extension .sql mime application x sql uniform type owner IBM released Start date 1986 df yes latest release version SQL 2008 latest release date Start date and age ... SQL Part 1 Framework SQL Framework SQL IPAc en icon s k ju l , often IPAc en s i k w l , ref cite book last Beaulieu first Alan title Learning SQL editor Mary E Treseler publisher ... 1897740.htm contribution More on Relational Algebra versus Calculus date 2005 04 15 quote SQL s code ... to characterise SQL as just idiosyncratic, but then I would, wouldn t I? I m also happy to omit the syncra ..., database schema schema creation and modification, and data access control. SQL was one of the first ... by Codd , it became the most widely used database language. ref name SQL Fundamentals ref name IBM sql cite web title Structured Query Language SQL publisher International Business Machines url http ... more details
otheruses PL disambiguation Infobox Top level domain name .pl background CCF image Image Dotpl.png .pl Internet domain registration 220px introduced 1990 type Country code top level domain status Active registry Naukowa i Akademicka Sie Komputerowa NASK sponsor Naukowa i Akademicka Sie Komputerowa NASK intendeduse Entities connected with flag Poland actualuse Very popular in Poland restrictions No restrictions stated structure Registrations can be made directly at second level, or at third level beneath various second level labels document disputepolicy http www.arbitraz.pl PIIT arbitration for Polish entities br http arbiter.wipo.int domains rules cctld expedited pl WIPO expedited arbitration for foreign entities website http www.dns.pl english dns.pl tt .pl tt is the Internet country code ... National Top Level Domain Registries CENTR . History The tt .pl tt domain was created in 1990, following ... countries. The first subdomain in tt .pl tt was tt .pwr.pl tt , belonging to the Wroc aw University ... prefer to create their own second level domain s, directly under tt .pl tt As of 2008 lc on , over ... http www.iana.org root whois pl.htm IANA tt .pl tt whois information http www.dns.pl english Domain name registry of tt .pl tt http www.dns.pl english zonestats.html Statistics of tt .pl tt http www.dns.pl ... policy.txt IDN registration policy in tt .pl tt ccTLD DEFAULTSORT PL Category Country code ... Registries members compu domain stub ar .pl ast .pl az .pl be .pl be x old .pl bs .pl bg .pl ca .pl cv .pl cs .pl cy .pl da .pl et .pl el .pl es .pl eo .pl eu .pl fa .pl fo .pl fr .pl xal .pl ko .pl hy .pl hr .pl bpy . id .pl os .pl is .pl it .pl krc .pl ka .pl lv .pl lb .pl hu .pl arz .pl ms .pl nah .pl nl .pl ja .pl ce .pl no .pl uz .pl nds .plpl .pl pt .pl crh .pl ro .pl ru .pl sah .pl sq .pl sk .pl szl .pl sr .pl sh .pl fi .pl sv Toppdom n P tl .pl tt .pl th .pl tg .pl tr .pl tk .pl uk .pl ur Pl. vi .pl fiu vro .pl war .pl yo .pl diq .pl zh .pl ... more details
SQL Developer may refer to Oracle SQL Developer , a free SQL IDE from Oracle Corporation PLSQL Developer, an IDE for PLSQL development from Allround Automations SOLYP SQL Developer, a generic proprietary database tool written by Jan Borchers disambig ... more details
Embedded SQL is a method of combining the computing power of a programming language and the database Data Manipulation Language manipulation capabilities of SQL . Embedded SQL statement programming statements are SQL statements written inline with the program source code of the host language. The embedded SQL statements are parsing parsed by an embedded SQL preprocessor and replaced by host language ... by the host compiler . This allows programmers to embed SQL statements in programs written in any ... SQL standards committee defined the embedded SQL standard in two steps a formalism called Module Language was defined, then the embedded SQL standard was derived from Module Language. ref name modulelang ... The Module Language Concept work SQL Module for Ada Programmer s Guide, Release 8.0, Chapter 1. Introduction to SQL Module publisher Oracle Corporation accessdate 2008 07 14 ref The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred to as the host language . A popular host language is C. The mixed C and embedded SQL is called Pro ... system this precompiler is called ECPG . Other embedded SQL precompilers are Pro Ada programming language Ada , Pro COBOL, Pro FORTRAN, Pro Pascal programming language Pascal , and Pro PL I . Systems that do not support Embedded SQL Microsoft SQL Server Embedded SQL for C has been deprecated as of Microsoft SQL Server 2008 although earlier versions of the product support it. ref cite web url http msdn.microsoft.com en us library ms143729.aspx title Deprecated Database Engine Features in SQL Server 2008 work SQL Server 2008 Books Online March 2009 publisher Microsoft accessdate 2009 04 10 ref MySQL MySQL does not support Embedded SQL. ref cite web url http dev.mysql.com tech resources articles precompiler for embedded sql.html title An Open Pre Compiler for Embedded SQL work MySQL DevZone Articles publisher Mysql accessdate 2009 04 10 ref Sybase Embedded SQL support has been discontinued ... more details
SQL Plus is an Oracle database Oracle command line utility program that can run SQL and PLSQL commands interactively or from a script. SQL Plus operates as a relatively simple tool with a basic command ... Bot retrieved archive archivedate 2007 11 09 ref SQL statements PLSQL blocks SQL Plus internal ... line utility for executing SQL and PLSQL commands available up to Oracle 10gR2 . ref SQL Worksheet ... browser. Use SQL Commands to run SQL and PLSQL statements. ... ref Oracle 11g Starting from Oracle .... ref bind variables, prefixed by a colon , which can interact with the PLSQL environment. Displayable ... PLSQL editors Category SQL clients bg SQL Plus es SQL Plus fr SQL Plus plSQL Plus pt SQL Plus ru ... in almost any Oracle software installation. Command types SQL Plus understands three categories of text ref name CommandRef cite web url http www.orafaq.com faq sqlplus title SQL Plus at orafaq.com ... software environment can launch SQL Plus, for example, by entering code sqlplus scott tiger code where the Oracle user code scott code has the password code tiger code . SQL Plus then presents a prompt with the default form of pre SQL> pre Interactive use can then start by entering a SQL statement terminated by a semicolon , a PLSQL block, or another command. For example pre SQL> select Hello world as example from dual EXAMPLE Hello world pre History The first version of SQL Plus was called ... UFI changed to SQL Plus before the release of this Which? date July 2009 version. As of 2010 the product continues to bear the name SQL Plus . Usage Graphical interfaces from Oracle or third parties have diminished the proportion of Oracle database end users who depend on the SQL Plus environment. Oracle shops typically continue to use SQL Plus scripts for batch updating or simple reports. Citation needed date November 2008 Oracle Corporation s wrappers gui fications replacements for SQL Plus include Oracle SQL Plus Worksheet, a component of Oracle Enterprise Manager OEM ref cite web url http ... more details
PL pgSQL Procedural Language PostgreSQL Structured Query Language is a procedural language supported by the PostgreSQL ORDBMS . It closely resembles Oracle database Oracle s PLSQL language. PL pgSQL, as a fully featured programming language , allows much more procedural control than SQL , including the ability to use loops and other control structures. Functions created in the PL pgSQL language can be called from an SQL statement, or as the action that a Database trigger trigger performs. PL pgSQL was created to be able to perform more complex operations and computations than SQL, while being easy to use, and is able to be defined as trusted by the server. ref citeweb url http www.postgresql.org docs current static plpgsql.html title PL pgSQL SQL Procedural Language accessdate 2007 11 15 ref Lots of examples of PLpgSQL using are in http www.pgsql.cz index.php PL pgSQL 28en 29 PL pgSQL tutorial . PL pgSQL is the only PL language installed by default for PostgreSQL, but many others are available, including http gborg.postgresql.org project pljava projdisplay.php PL Java , http www.postgresql.org docs current interactive plperl.html PL Perl , http www.commandprompt.com community plphp plPHP , http www.postgresql.org docs current interactive plpython.html PL Python , http www.joeconway.com plr PL R , http raa.ruby lang.org project pl ruby PL Ruby , http plsh.projects.postgresql.org PL sh , and http www.postgresql.org docs current interactive pltcl.html PL Tcl . References reflist Category SQL Category PostgreSQL Category Data centric programming languages de PL pgSQL es PL PgSQL fr PL pgSQL it PL pgSQL ja PL pgSQL plPL pgSQL ru PL pgSQL ... more details
Server Enterprise Sybase PLSQLPLSQL Oracle SQLSQL ANSI Microsoft SQL Server SQL Server Microsoft ...Transact SQL T SQL is Microsoft s and Sybase s proprietary extension to SQL . SQL, often expanded to Structured Query Language, is a SQL Standardization standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using Declarative programming declarative statements. T SQL expands on the SQL standard to include Procedural programming procedural programming, local variable s, various support functions for string processing, date processing, mathematics, etc. and changes to the Delete SQL DELETE and update SQL UPDATE statements. These additional features make Transact SQL Turing complete . Transact SQL is central to using Microsoft SQL Server . All applications that communicate with an instance of SQL Server do so by sending Transact SQL statements to the server, regardless of the user interface of the application. Flow control Keywords for flow control in Transact SQL include code BEGIN code and code END code , code BREAK code ... and UPDATE statements In Transact SQL, both the DELETE and UPDATE statements allow a FROM clause to be added ... f.id WHERE f.name Idle source BULK INSERT BULK INSERT is a Transact SQL statement that implements ... html sqlug title.htm Sybase Transact SQL User s Guide http msdn2.microsoft.com en us library aa260642 SQL.80 .aspx Transact SQL Reference for SQL Server 2000 MSDN http msdn2.microsoft.com en us library ms189826.aspx Transact SQL Reference for SQL Server 2005 MSDN http msdn.microsoft.com en us library bb510741 SQL.100 .aspx Transact SQL Reference for SQL Server 2008 MSDN Category SQL Category Data centric programming languages cs Transact SQL de Transact SQL es Transact SQL fr Transact SQL id Transact SQL is Transact SQL it Transact SQL ja Transact SQLpl Transact SQL pt Transact SQL ru Transact SQL zh Transact SQL ... more details
An SQL INSERT statement adds one or more records to any single Table database table in a relational database ... code CHECK code constraints , and Null SQL code NOT NULL code constraints . If a syntax error ... instead. Example source lang sql INSERT INTO phone book name, number VALUES John Doe , 555 1212 ... 2 in the table. source lang sql INSERT INTO phone book VALUES John Doe , 555 1212 source Advanced forms Multirow inserts A SQL feature since SQL 92 is the use of row value constructors to insert multiple rows at a time in a single SQL statement source lang sql INSERT INTO table column a , column ... by IBM DB2 DB2 , Microsoft SQL Server SQL Server since version 10.0 ie. 2008 , PostgreSQL ... in the phone book table source lang sql INSERT INTO phone book VALUES John Doe , 555 1212 , Peter Doe , 555 2323 source which may be seen as a shorthand for the two statements source lang sql INSERT .... To insert multiple rows in MS SQL you can use such a construction source lang sql INSERT INTO phone ... SQL statement according to the SQL standard SQL 2003 due to the incomplete subselect clause ... lang sql INSERT INTO phone book SELECT John Doe , 555 1212 FROM DUAL UNION ALL SELECT Peter Doe , 555 ..., or as shown above source lang sql INSERT INTO phone book SELECT John Doe , 555 1212 FROM LATERAL VALUES 1 AS t c UNION ALL SELECT Peter Doe , 555 2323 FROM LATERAL VALUES 1 AS t c source Oracle PLSQL supports the INSERT ALL statement, where multiple insert statements are terminated by a SELECT ref cite web url http psoug.org snippet Oracle PLSQL INSERT ALL 589.htm title Oracle PLSQL INSERT ALL work psoug.org accessdate 2010 09 02 ref source lang sql INSERT ALL INTO phone book VALUES John ... and insert it directly into the table. All this is done in a single SQL statement that does not involve ... is started. An example is given below. source lang sql INSERT INTO phone book2 SELECT FROM phone book ... are not the same. source lang sql INSERT INTO phone book2 name , phoneNumber SELECT name , phoneNumber ... more details
PL Perl Procedural Language Perl is a procedural language supported by the PostgreSQL RDBMS . PL Perl, as an imperative programming language , allows more control than the relational algebra of SQL . Programs created in the PL Perl language are called functions and can use most of the features that the Perl language provides, including common flow control structures and syntax that has incorporated regular expressions directly. These functions can be evaluated as part of a SQL statement, or in response to a Event driven programming trigger or wiktionary rule rule . The design goals of PL Perl were to create a loadable procedural language that can be used to create functions and trigger procedures, adds control structures to the SQL language, can perform complex computations, can be defined to be either http www.postgresql.org docs current static plperl trusted.html trusted or untrusted by the server, is easy to use. PL Perl is one of many PL languages available for PostgreSQL PL pgSQL http gborg.postgresql.org project pljava projdisplay.php PL Java , http plphp.commandprompt.com plPHP , http www.postgresql.org docs current interactive plpython.html PL Python , http www.joeconway.com plr PL R , http raa.ruby lang.org list.rhtml?name pl ruby PL Ruby , http developer.postgresql.org petere pgplsh PL sh , and http www.postgresql.org docs current interactive pltcl.html PL Tcl . References http www.postgresql.org docs current static plperl.html PostgreSQL PL Perl documentation Category Data management Category PostgreSQL Category Data centric programming languages ru PL Perl ... more details
SQL Server may refer to Any database server that implements the SQL Structured Query Language Microsoft SQL Server , a specific implementation of a relational database server from Microsoft Sybase SQL Server , a relational database server developed by Sybase SQL Server magazine SQL Server magazine , a trade publication and web site owned by Penton Media disambig Category Servers cs SQL Server de SQL Server hr SQL Server it SQL Server nl SQL Server ja SQL Server ro SQL Server ru SQL Server uk SQL Server ... more details
A PREPARE statement in SQL prepares a statement database statement for execute sql execution at a later time. SQL DEFAULTSORT Prepare Sql Category SQL keywords Compu lang stub ... more details
Mimer SQL is an SQL based relational database management system from the Sweden Swedish company Mimer Information Technology AB formerly Upright Database Technology AB , which has been developed and produced since the 1970s. The Mimer SQL database engine is available for Microsoft Windows , Mac OS X , Linux , Symbian OS , Unix , VxWorks and OpenVMS . Unlike other competing DBMSes, Mimer only implements optimistic concurrency control . ref cite web url http developer.mimer.com features feature 15.htm title Transaction Concurrency Optimistic Concurrency Control work Mimer Developers Features date 26 February 2010 ref References references External links http www.mimer.com Category Proprietary database management systems database software stub pl Mimer SQL ... more details
it SQL injection he SQL ka SQL lv SQL injekcija nl SQL injectie ja SQLplSQL ...SQL injection is a code injection technique that exploits a security vulnerability occurring in the database ... is either incorrectly filtered for string literal escape sequences escape characters embedded in SQL ... one programming or scripting language is embedded inside another. SQL injection attacks are also known as SQL insertion attacks. ref Watson, Carli 2006 Beginning C 2005 databases ISBN 978 0 470 04406 ... characters This form of SQL injection occurs when user input is not filtered for escape sequences escape characters and is then passed into an SQL statement. This results in the potential manipulation ... source This SQL code is designed to pull up the records of the specified username from its table of users. However, if the userName variable is crafted in a specific way by a malicious user, the SQL ... as pre or 1 1 pre Or using comments to even block the rest of the query there are three types of sql comments ref citation title IBM Informix Guide to SQL Syntax. Overview of SQL Syntax > How to Enter SQL Comments publisher IBM url http publib.boulder.ibm.com infocenter idshelp v10 index.jsp?topic com.ibm.sqls.doc sqls36.htm ref pre or 1 1 or 1 1 or 1 1 pre renders this SQL statement by the parent language source lang sql SELECT FROM users WHERE name or 1 1 source If this code were to be used ... SQL statement as follows source lang sql SELECT FROM users WHERE name a DROP TABLE users SELECT FROM userinfo WHERE t t source While most SQL server implementations allow multiple statements to be executed with one call in this way, some SQL APIs such as PHP s code mysql query code function do not allow ... t stop them from modifying queries. Incorrect type handling This form of SQL injection occurs .... This could take place when a numeric field is to be used in a SQL statement, but the programmer makes ... will drop delete the users table from the database, since the SQL would be rendered as follows source ... more details
The SQL MED , or Management of External Data , extension to the SQL standard is defined by ISO IEC 9075 9 2003. SQL MED provides extensions to SQL that define foreign data wrappers and datalink types to allow SQL to manage external data . External data is data that is accessible to, but not managed by, an SQL based DBMS . This standard can be used in the development of federated database system s. See also SQLSQL 2003 References Empty section date July 2010 External links http www.sigmod.org publications sigmod record 0209 jimmelton.pdf view SQL MED A Status Report Category SQL database stub ru SQL MED ... more details
The SQL OLB , or Object Language Bindings , extension to the SQL standard is defined by ISO IEC 9075 10 2003. SQL OLB defines the syntax and symantics of SQLJ , which is SQL embedded in Java programming language Java . The standard also describes mechanisms to ensure binary portability of SQLJ applications, and specifies various Java packages and their contained classes. See also SQLSQL 2003 External links http www.jcc.com sql.htm Short description database stub Category SQL ru SQL OLB ... more details
es Adaptive Server Anywhere it SQL Anywhere Studio pl Adaptive Server Anywhere QuickiWiki Look Up QuickiWiki ...Refimprove date October 2009 SQL Anywhere is a Relational database management system relational database management system RDBMS product from the company Sybase iAnywhere , a subsidiary of Sybase . Features SQL Anywhere can be run on Microsoft Windows Windows , Windows CE , Mac OS X , and various UNIX platforms, including Linux , AIX , HP UX and Solaris operating system Solaris . Database files are independent of the operating system , allowing them to be copied between supported platforms. The product provides several standard interfaces ODBC , JDBC , and ADO.NET and a number of special interfaces such as PHP and Perl . The engine supports stored procedure s, user functions using Watcom SQL , T SQL , Java software platform Java , or C programming language C C , Database trigger triggers , referential ... files and client server communication. Uses SQL Anywhere is used in several contexts, including ... QuickBooks ref cite web title QuickBooks replaces its flat file system with SQL Anywhere from ... server based RDBMS systems. History Initially created by Watcom as Watcom SQL . Version 3 1992 Watcom acquired by PowerSoft in 1993 Watcom SQL shipped with their visual programming environment PowerBuilder ... Watcom SQL was renamed SQL Anywhere . Version 5 1995 SQL Remote data replication graphical administration ... server Version 10 2006 renamed SQL Anywhere high availability , intra query parallel computing parallelism , materialized view s ref cite web title Sybase iAnywhere Announces the Release of SQL Anywhere ... Availability of SQL Anywhere 11 url http www.sybase.com detail?id 1057559 publisher Sybase press ... Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12 url http www.sybase.com ... SQL Anywhere official product page http www.sybase.com ianywhere Sybase iAnywhere main page http www.da soft.com anydac SQL Anywhere and more Data Access Components for Embarcadero Delphi Category Proprietary ... more details
unreferenced date July 2010 The SQL CLI , or Call Level Interface , extension to the SQL standard is defined in ISO IEC 9075 3 2003. This extension defines common interfacing components structures and procedures that can be used to execute SQL statements from applications written in other programming languages. The SQL CLI extension is defined in such a way that SQL statements and SQL CLI procedure calls are treated as separate from the calling application s source code. See also SQLSQL 2003 References Empty section date July 2010 External links Category SQL database stub ru SQL CLI ... more details
Unreferenced date January 2009 The SQL JRT , or SQL Routines and Types for the Java Programming Language , extension to the SQL standard is defined by ISO IEC 9075 13 2003. SQL JRT specifies the ability to invoke static Java programming language Java methods as routines from within SQL applications. It also calls for the ability to use Java classes as SQL structured user defined types. See also SQL 2003 References Empty section date July 2010 External links DEFAULTSORT Sql Jrt Category SQL database stub ru SQL JRT ... more details
Unreferenced date December 2009 Context date October 2009 Cleanup date March 2008 Meta SQL Use with reference to PeopleSoft Meta SQL expands to platform specific SQL substrings, causes another function to be called, or substitutes a value. Meta SQL constructs are used in functions that pass SQL strings, such as the following SQLExec. Scroll buffer functions ScrollSelect and its relatives . PeopleSoft Application Designer dynamic and SQL views. Some Rowset class methods Select, SelectNew, Fill, and so on. . The SQL class. PeopleSoft Application Engine programs. Some Record class methods Insert, Update, and so on. . COBOL functions. Meta SQL Element Types There are three types of meta SQL elements Construct Constructs are a direct substitution of a value, and help to build or modify a SQL statement. Examples include Bind, InsertSelect, and List. Function Functions perform actions or cause another function to be called. Examples include ClearCursor, Execute, and ExecuteEdits. Meta variable. Meta variables enable substitution of text within SQL statements. Examples include AsOfDate, Comma, and JobInstance. Meta SQL Placement Considerations Not all meta SQL can be used by all programs. Some meta SQL can be used only in Application Engine programs. Other meta SQL can only be used as part of a SQL statement in a SQL or dynamic view. The following table lists available meta SQL elements and where each element can be used. If a meta SQL construct, function, or meta variable is supported in PeopleCode, it is supported in all types of PeopleCode programs that is, in Application Engine PeopleCode programs actions , component interface PeopleCode programs, and so on. Note. Even if a meta SQL element is used in PeopleCode, you cannot use meta SQL like a built in function. You can use meta SQL in the SQLExec function, the Select method, the Fill method, and so on. Note. Meta SQL is not available in SQR DEFAULTSORT Meta Sql Category SQL ... more details
A code HAVING code clause in SQL specifies that an SQL code Select SQL SELECT code statement should only return rows where aggregate values meet the specified Condition SQL condition s. It was added When date February 2011 to the SQL language because the code Where SQL WHERE code keyword could not be used with aggregate functions. ref cite web url http www.w3schools.com SQLsql having.asp title SQL HAVING Clause publisher w3schools.com quote The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions. ref Examples To return a list of department IDs whose total sales exceeded 1000 on the date of January 1, 2000, along with the sum of their sales on that date source lang sql SELECT DeptID, SUM SaleAmount FROM Sales WHERE SaleDate 01 Jan 2000 GROUP BY DeptID HAVING SUM SaleAmount 1000 source Referring to the sample tables in the Join SQL example, the following query will return the list of departments who have more than 1 employee source lang sql SELECT DepartmentName, COUNT FROM employee,department WHERE employee.DepartmentID department.DepartmentID GROUP BY DepartmentName HAVING COUNT 1 source References Reflist External links http www.databasejournal.com features mysql article.php 3469351 The HAVING and GROUP BY SQL clauses http www.w3schools.com sqlsql functions.asp SQL Aggregate Functions SQL DEFAULTSORT Having Sql Category SQL keywords Category Articles with example SQL code database stub compu lang stub ru HAVING SQL sq Having SQL uk Having SQL ... more details
Encyclopedia
top
