
	Where results make sense

Topic: PL SQL

Related Topics

SQL

Oracle database

DB2

Oracle Corporation

Database management system

Ada programming language

Database

Relational model

X86

Advanced light rapid transit

Chicano

Dictionary of National Biography

HHT

Economic depression

Zach De La Rocha

In the News (Wed 30 Dec 09)

Northern Trust

Marvin Harrison

Peter Chernin

Gary Locke

Match Play

Penelope Cruz

Mickey Rourke

AR Rahman

Danny Boyle

Hugh Jackman

	What is PL/SQL ?
		As you may have noticed from the preceding section, SQL statements are very concise and powerful, but do not do more as a group than they do individually.
		All of the SQL datatypes, which are the datatypes that you can store in the database, fall into this category.
		SQL statements are explained earlier in this chapter; assignments and flow-control statements are explained in the sections that follow.
	lambda.uta.edu /cse5331/spring98/plsql.html (7648 words)

	plsql tutorial \| freejavaguide.com
		Normal sql does not have any procedural capabilities moreover u can only pass one statement at a time to Oracle Engine.
		PL SQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL.
		PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL.
	www.freejavaguide.com /plsql.htm (1695 words)

	PostgreSQL: Documentation: Manuals: PostgreSQL 8.1: PL/pgSQL - SQL Procedural Language
		The instruction tree fully translates the PL/pgSQL statement structure, but individual SQL expressions and SQL commands used in the function are not translated immediately.
		SQL is the language PostgreSQL and most other relational databases use as query language.
		But every SQL statement must be executed individually by the database server.
	www.postgresql.org /docs/8.1/interactive/plpgsql.html (1085 words)

	Oracle PL/SQL Pipeline - Quest Software's Information Portal for Oracle PL/SQL Developers
		Set SQL trace on or off for your session and also include a "tag" in the trace file so you locate your output easily.
		SQL CONNECT BY queries use space indentation to show levels of recursive relations between records.
		Ideally, SQL tuning should start from the time the SQL is coded and continue throughout the application lifecycle into debugging, testing, production and maintenance.
	www.revealnet.com /pipelines/plsql/archives.htm (5132 words)

	PL/SQL TUTORIAL BY SANJAY AHUJA
		A transaction is a series of SQL statements that either succeed or fail as a unit.
		SQL statements within the subprogram are processed in the same way.
		The SQL is static (or static SQL), which means that the content of the SQL statement is determined at compile time.
	sanjayahuja.tripod.com /tech/plsql/plsql.html (8073 words)

	Chapter 4 Native Dynamic SQL in Oracle8i
		Dynamic SQL comes in extremely handy when you are building ad hoc query systems, when you need to execute DDL inside PL/SQL, and just generally when you don't know in advance exactly what you need to do or what the user will want to do.
		The static version requires a static SQL statement after the FOR keyword, whereas with NDS, the SQL string is always either a literal string or an expression that evaluates to a string.
		Since it is the same SQL statement, your application is more likely to be able to take advantage of the pre-parsed cursors that are cached in the System Global Area (SGA) of the database.
	www.oreilly.com /catalog/ornewfeatures/chapter/ch04.html (8055 words)

	Embedded PL/SQL
		Like host variables in a SQL statement, host variables in a PL/SQL block must be prefixed with a colon.
		In dynamic SQL Method 4, you cannot bind a host array to a PL/SQL procedure with a parameter of type "table." For more information, see "Using Method 4".
		When you are connected to the external procedure context, any additional connection is not permitted and results in a runtime error.
	www.csee.umbc.edu /help/oracle8/server.815/a68022/plsql.htm (5105 words)

	Oracle Database Development Tools from SQL Navigator by Quest Software (Site not responding. Last check: 2007-10-20)
		SQL Navigator® is a PL/SQL development solution that streamlines workflow by adding a drag-and-drop, graphical user interface to the PL/SQL development environment.
		SQL Navigator speeds the development of Oracle-based applications and combines coding, tuning, debugging, Web development and version control to deliver higher quality applications and save valuable time.
		The SQL Navigator® Suite includes all of the features and functionality of SQL Navigator Xpert plus DataFactory® Developer Edition, Benchmark Factory® for Databases and Toad Data Modeler.
	www.quest.com /sql_navigator (291 words)

	Introduction to PL/SQL
		Need for PL/SQL — declarative vs. procedural — anonymous blocks — debugging — a first program — code compilation — code execution — procedures and functions — PL/SQL in SQL — SQL in PL/SQL — cursors and loops — operators and built-in functions reference tables.
		SQL statements are defined in term of constraints we wish to fix on the result of a query.
		Remember that it is advisable to type your program in an external editor, as you have done with SQL (see Introduction to Oracle).
	w2.syronex.com /jmr/edu/db/introduction-to-plsql (539 words)

	PL/SQL - Wikipedia, the free encyclopedia
		The underlying SQL functions as a declarative language.
		SQL does not readily provide "first row" and "rest of table" accessors, and it cannot easily perform some constructs such as loops.
		SQL statements can make explicit in-line calls to PL/SQL functions, or can cause PL/SQL triggers to fire upon pre-defined Data Manipulation Language (DML) events.
	en.wikipedia.org /wiki/PL/SQL (1320 words)

	Oracle PL/SQL Pipeline - Quest Software's Information Portal for Oracle PL/SQL Develop
		One of the most common reasons people appear to be using dynamic SQL is to handle the case when the user can specify one, two or any amount of values to be searched on.
		Notice that the SQL in red above does not contain any literals - it doesn't matter what the list of people being sought is, we can re-use the same SQL over and over.
		So (for example), its trivial to change our demo so that rather than passing a string list of names, you could pass any SQL statement to generate the list of surnames that we are interested in.
	www.revealnet.com /pipelines/plsql/tips.htm (3392 words)

	PL/SQL
		There are bazillions of syntax idiosyncrasies, to the point that the only way to write syntactically correct code is with a syntax manual on your desk, or by cut, paste and modify.
		Its misnamed because it's data type can be used as a field type for a SQL table, making that field a "nested" table.
		Since every query returns a table, they can be queried like a table, save typing effort and allow people that are not so familiar with SQL to find all their information in one neat table.
	www.schacherer.de /frank/tech/tools/plsql.html (1705 words)

	An Overview of PL/SQL (Site not responding. Last check: 2007-10-20)
		The "PL" in PL/SQL is short for Procedural Language.
		It is an extension to SQL that allows you to create PL/SQL programs that contain standard programming features such as error handling, flow-of- control structures, and variables, all allowing you to manipulate Oracle data.
		This is somewhat different to the operation of SQL Server's T-SQL in which you can check the value of @@Error after any statement, provided that the error was of a trappable nature.
	www.vbip.com /books/1861003927/chapter_3927_11.asp (830 words)

	Oracle PL/SQL (Site not responding. Last check: 2007-10-20)
		PL/SQL is Oracle's procedural langauge extension to SQL.
		Oracle implicitly opens a cursor to process each SQL statement not associated with an explicit declared cursor.
		Oracle executes the database triggers automatically whenever a given SQL operation affects the table.
	www.cs.armstrong.edu /liang/oracle/oracle_plsql.html (550 words)

	AMIS Technology blog » Devel. + PL/SQL tools
		Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life.
		Undoubtedly, you are familiar with Word Search puzzles, the type of puzzle that present a matrix with a mash of letters in which specific words have been hidden.
		While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a awkard solution to a problem that has a much more elegant one.
	technology.amis.nl /blog/?cat=24 (1604 words)

	Oracle PL/SQL Programming, 3rd Ed. Supplemental Files
		Be sure to run ch12_clob02.sql first in order to populate the waterfalls table with the data read by this example.
		Utility that relies on native dynamic SQL to allow to view the WHERE-restricted contents of any column in any table.
		Utility that relies on native dynamic SQL to allow to view the WHERE-restricted contents of any date column in any table.
	examples.oreilly.com /oraclep3/individual_files (2192 words)

	PL/SQL
		In potentially ambiguous SQL statements, the names of local variables and formal parameters take precedence over the names of database tables.
		A transaction is a series of SQL data manipulation statements that does a logical unit of work.
		The triggering event specifies the SQL data manipulation statement that affects the table.
	lambda.uta.edu /cse5331/spring98/plsql_manual.html (10544 words)

	Overview of PL/SQL (Site not responding. Last check: 2007-10-20)
		PL/SQL was initially developed for automating SQL transactions but has since been transformed into a substantial development platform for complex applications.
		You can work around this restriction by using the dynamic SQL package dbms_sql, which allows for data definition statements to be created dynamically at run time and have them executed.
		When the SQL statement is executed, there is no need to check the statement for syntax, object references or determine the execution plan.
	home.earthlink.net /~mweber11/pl_sql.html (4026 words)

	Embedded PL/SQL
		The use of host tables used in a dynamic SQL Method 2 statement (see "Using Method 2") may have two different interpretations based on the presence or absence of the keyword to EXECUTE the ARRAYLEN statement.
		If there are problems with this, you may wish to free all child cursors after a SQL statement is executed.
		In dynamic SQL Method 4, a host table cannot be bound to a PL/SQL procedure with a parameter of type TABLE.
	www.cs.uvm.edu /oracle9doc/appdev.901/a89865/pco06pls.htm (5484 words)

	O'Reilly -- Learning Oracle PL/SQL? Here's What to Expect
		And you soon discovered that SQL might be a decent tool for creating and manipulating data in relational tables, but it only takes you so far; in fact, SQL was never designed as a complete substitute for a real language.
		Part of the reason for the misperception about PL/SQL is because of the conventional textbook description of PL/SQL as Oracle's "procedural language extension to SQL." While such a description is at least partially true--it is a procedural language--it can be quite misleading to think of it merely as a SQL's extension.
		Almost without exception, new PL/SQL programmers are amazed and delighted when they discover how easy it is to interact with the database using SQL statements, particularly if they've had to suffer through the way other languages force this union.
	www.oreillynet.com /pub/a/oreilly/oracle/news/plsql_1201.html (2213 words)

	Oracle FAQ: PL/SQL
		Starting from Oracle8i one can use the "EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL statements (statements created at run-time).
		The consequence is that a SQL statement can work in SQL*Plus, but will give an error in PL/SQL.
		This makes it much more efficient as SQL statements are not stripped off and sent to the database individually.
	www.orafaq.net /faqplsql.htm (2059 words)

	PL/SQL
		If the PL/SQL block contains some SQL statements, then only these statements are sent to be executed at the server.
		Therefore, PL/SQL procedures are not directly callable from SQL statements.
		There are occasions where package's purity is less than the function which causing the function not callable from SQL.
	www.cse.unsw.edu.au /~lxue/9311/plsql.html (1588 words)

	Oracle PL/SQL Programming
		That is, you provide the name of the table, an optional where clause and column name filter, and the "in table" procedure displays the contents of the table matching your criteria.
		Method 4 means that at the time you are writing your code, you don't know either (a) how many columns you are querying or (b) how many bind variables are in the dynamic string.
		While this supplied package is no longer the first choice for most dynamic SQL requirements, it is the only mechanism available in PL/SQL to implement method 4 dynamic SQL.
	www.oracleplsqlprogramming.com /resources.html (1136 words)

	Amazon.com: Oracle8 PL/SQL Programming: Books: Scott Urman (Site not responding. Last check: 2007-10-20)
		Evaluate Microsoft SQL Server 2005 — See what customers are saying: Free case studies, testimonials & more.
		PL SQL — DB Tools for Oracle is an integrated set of must-have tools for monitoring, tuning, diagnosing, coding, reverse-engineering, creating, editing, debugging and reporting for Oracle databases.
		The explinations of the syntax vary between encyclopedic, as in Chapeter 5: Built-in SQL Functions and lacking completenes as in Chapter 7: Subprograms: Procedures and Functions.
	www.amazon.com /Oracle8-SQL-Programming-Scott-Urman/dp/0078823056 (1632 words)

	O'Reilly Store -- Oracle
		Updated to cover Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on practical, expert best-practices and on Oracle-specific SQL technique than any other… Read more.
		One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently.
		Everything Oracle developers and DBAs need to know about standard SQL (Structured Query Language) and Oracle's extensions to it is in this single, concise reference volume.
	oracle.oreilly.com /utplsql (1510 words)

	ONLamp.com -- Writing PostgreSQL Functions with PL/pgSQL
		It's much more powerful than pure SQL in that it supports variables, conditional expressions, looping constructs, exceptions, and the like.
		Because it natively supports all of PostgreSQL's SQL syntax, you can consider it a superset of PostgreSQL SQL.
		It also respects all data types and their associated functions and operators, and is completely safe for use inside of the server.
	www.onlamp.com /pub/a/onlamp/2006/05/11/postgresql-plpgsql.html (929 words)

	SwisSQL Oracle to Java Migration Tool: PL/SQL To Java Migration Tools, Porting PL/SQL To Java, Migrate Oracle PL/SQL to ...
		Support for conversion of OPEN FOR (Native Dynamic SQL) statements with "USING" construct.
		SQL 'FOR UPDATE' clause in 'SELECT' statement and 'CURRENT OF' clause in 'UPDATE' statement are supported.
		Oracle SQL queries are converted to equivalent Target Database SQL Queries (SQL Server, DB2, MySQL, AnsiSQL, PostgreSQL, Informix, TimesTen) and used within Java code.
	www.swissql.com /products/oracle-to-java/oracle-to-java.html (735 words)

	PL/SQL GURU
		Prior to Oracle8, you could create data structures (tables) and you could write programs to manipulate the data (most optimally as a package built "around" the table), but there was no native way to link these two aspects together tightly.
		In what has got to be one of the biggest surprises of the object-relational phase of the War of the Database Vendors, Oracle has decided to use the "a" word: array.
		One really nice feature of nested tables is (as you might expect given their modeling on database tables) that you can use them inside SQL statements.
	www.oreview.com /9707plsq.htm (3498 words)

	SQL Tutorial
		SQL is a standard computer language for accessing and manipulating databases.
		In this tutorial you will learn how to use SQL to access and manipulate data in Oracle, Sybase, SQL Server, DB2, Access, and other database systems.
		The ASP Developer Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
	www.w3schools.com /sql/default.asp (426 words)

	iSelfSchooling - Manuscripts for SQL and PL/SQL
		Learn how to use command line editor which it is native to SQL*PLUS.
		Learn how Oracle makes provisions for you to utilize your favorite text editor to edit the statement created in "afiedt.buf," the file into which SQLPLUS stores the most recently executed SQL* statement.
		Learn how to declare a cursor to list the department name (dname), total number of employees (ttemp), total salary (ttsal), and average salary (avsal) for each department from the department table and employee table.
	www.iselfschooling.com /iss4sqlplsql.htm (695 words)

Try your search on: Qwika (all wikis)