|
| |
| | SQL - Wikipedia, the free encyclopedia |
 | | However, it also makes it possible for SQL source code to be produced (and optimized) by software, leading to the development of a number of natural language database query languages, as well as 'drag and drop' database programming packages with 'object oriented' interfaces. | | | SQL is the most popular computer language used to create, modify and retrieve data from relational database management systems. | | | Technically, SQL is a declarative computer language for use with "relational databases". |
|
http://en.wikipedia.org/wiki/SQL
(2107 words)
|
|
| |
| | PL/SQL - Wikipedia, the free encyclopedia |
| | PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary server-based procedural extension to the SQL database language. | | | Programmers can also use Dynamic SQL to execute DML where they do not know the exact content of the statement in advance. | | | PL/SQL functions analogously to the embedded procedural languages associated with other relational databases. |
|
http://en.wikipedia.org/wiki/PL/SQL
(1042 words)
|
|
| |
| | Oracle FAQ: PL/SQL |
| | The consequence is that a SQL statement can work in SQL*Plus, but will give an error in PL/SQL. | | | PL/SQL respect object privileges given directly to the user, but does not observe privileges given through roles. | | | Starting from Oracle8i one can use the "EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL statements (statements created at run-time). |
|
http://www.orafaq.com/faqplsql.htm
(2048 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. | | | Dynamic SQL is, of course, suited perfectly to this scenario, and I was able to fix their problem in no time at all (well, to be honest, at the time I fixed it using DBMS_SQL, but here's the NDS implementation): |
|
http://www.oreilly.com/catalog/ornewfeatures/chapter/ch04.html
(8055 words)
|
|
| |
| | Quest : Products : SQL Navigator : Overview |
| | 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. | | | Optional Add-on Modules: Extend the reach of SQL Navigator with powerful add-ons designed to provide intelligence and optimize PL/SQL server-side development. | | | The SQL Navigator® Suite includes all of the features and functionality of SQL Navigator Xpert plus DataFactory® Developer Edition, Benchmark Factory® for Databases and QDesigner™ PhysicalArchitect. |
|
http://www.quest.com/sql_navigator
(259 words)
|
|
| |
| | The BNF Web Club Language SQL, ADA, JAVA, MODULA2, PL/SQL, ... |
| | SQL as implemented by Oracle(tm) DBMS version 7. | | | PL/SQL A procedural language extension to SQL used in Oracle(tm) DBMS version 7. | | | More languages may eventually be added, whenever we find more time... |
|
http://cui.unige.ch/db-research/Enseignement/analyseinfo
(416 words)
|
|
| |
| | Oracle PL/SQL Pipeline - Quest Software's Information Portal for Oracle PL/SQL Developers |
| | SQL> create table CP (x number not null, y number); Table created. | | | SQL> analyze table cp estimate statistics; Table analyzed. | | | The moral of the story is just because these functions are labeled as analytics, don’t be afraid to investigate them for their other benefits as well - mainly cheaper queries. |
|
http://www.revealnet.com/pipelines/plsql/tips.htm
(3781 words)
|
|
| |
| | Fast Guide: PL/SQL |
| | Unique to Oracle, PL/SQL is the procedural language extension to the structured query language (SQL). | | | The big joke about the name "SQL" is that it is not really structured, is not just for queries, and (some argue) is not even a real language. | | | It is useful for building ad hoc query systems and executing DDL inside PL/SQL, and it is often needed in Web-based applications. |
|
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci969305,00.html
(1120 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. | | | 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. | | | 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. |
|
http://oracle.oreilly.com/news/plsql_1201.html
(2172 words)
|
|
| |
| | Know Dot Net - A Brief Intro to PL/SQL |
| | However, SQL lacks many constructs that have become staples of modern programming and every real database implements its own flavor of SQL. | | | As you may notice, there's nothing different here and provided that the object names are the same, this query would work with most RDBMS systems. | | | For most basic queries, you can get away with good ol' SQL, but I'll walk you through a few other examples. |
|
http://www.knowdotnet.com/articles/plsql.html
(336 words)
|
|
| |
| | Escaping to the procedural world |
| | There are no clean ways in standard SQL to say "do this just for the first N rows" or "do something special for a particular row if its data match a certain pattern". | | | For example, with AOLserver we generally program in Tcl, a procedural language, and read the results of SQL queries. | | | It returns 0 for an exact match, 1 for a chemical whose name begins with the query string, and 2 in all other cases (remember that this is only used in queries where a LIKE clause ensures that every chemical name at least contains the query string. |
|
http://philip.greenspun.com/sql/procedural.html
(891 words)
|
|
| |
| | PL/SQL |
| | In potentially ambiguous SQL statements, the names of local variables and formal parameters take precedence over the names of database tables. | | | PL/SQL is Oracle's procedural language extension to SQL, the relational database language. | | | The triggering event specifies the SQL data manipulation statement that affects the table. |
|
http://ugweb.cs.ualberta.ca/~c391/manual/chapt9.html
(10733 words)
|
|
| |
| | PL/SQL |
| | There are occasions where package's purity is less than the function which causing the function not callable from SQL. | | | - Parallel query execution is supported as SQL statements in PL/SQL function may be executed in parallel. | | | Otherwise, superset of data need to be retrieved and processed by the application; this saves query cost as well as network cost |
|
http://www.cse.unsw.edu.au/~lxue/9311/plsql.html
(1588 words)
|
|
| |
| | Using PL/SQL |
| | PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. | | | Notice we said ``tuple'' rather than ``tuples,'' since the select-statement only works if the result of the query is a single tuple. | | | If the query returns more than one tuple, you need to use a cursor, as described in the next section. |
|
http://www.cs.du.edu/~leut/3421/or-plsql.html
(2102 words)
|
|
| |
| | PL/SQL Tutorial |
| | PL/SQL is procedural programming language that uses sequencial instructions to process data. | | | DBMS_OUTPUT.PUT_LINE() displays the program output whether it's strings or variables. | | | The following is simple PL/SQL program that calculates some one's age: |
|
http://www.geocities.com/cliktoprogram/plsql/introduction.html
(226 words)
|
|
| |
| | The Oracle (tm) Users' Co-operative FAQ - Index |
| | Is it possible to write a trigger referencing more than one table - I want a trigger to audit a master/detail pair. | | | Is it possible to return a set of results from SQL*Plus to a UNIX variable ? | | | In documentation about tuning SQL, I see references to parse trees. |
|
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
(5354 words)
|
|
| |
| | Oracle/PLSQL Topics |
| | PLSQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL. | | | PLSQL stands for "Procedural Language extensions to SQL", and can be used in Oracle databases. |
|
http://www.techonthenet.com/oracle
(67 words)
|
|
| |
| | Oracle FAQ: PL/SQL Books |
| | This book is written in a format that user's with only SQL knowledge and are brand new to PL/SQL can learn the fundamentals of PL/SQL programming. | | | This book covers it all - the SQL you need to be able to write PL/SQL, and then actual PL/SQL procedures, functions, triggers, and packages. | | | In this introductory section, the reader learns how to create tables, write INSERT statements, and then select the data back out via the SELECT statement. |
|
http://www.orafaq.com/books/plsql.htm
(2979 words)
|
|
| |
| | Product Review: PL/SQL Developer: ASPAlliance |
| | To optimize the SQL statements in your program units, Oracle's Explain Plan utility can be a big help by showing the execution path of a statement. | | | A project consists of a collection of source files that you have been working with which can be anything from a SQL Script, Procedure, Function, and Trigger just to name a few. | | | As you are working within a SQL Script for example you may right click add select the TODO option. |
|
http://aspalliance.com/614
(717 words)
|
|
| |
| | PL/SQL procedures for data extraction taking too long |
| | A simple SQL statement, if possible, would be preferrable to any PL/SQL block to load data. | | | I have a white paper on my Web site titled "Data Loading with External Tables," which discusses a sample performance case loading data in multiple ways. | | | In this case, the source table is in a remote database, accessed through a database link. |
|
http://whatis.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid604773_tax294550,00.html
(334 words)
|
|
| |
| | Ixora Q & A - PL/SQL |
| | I've traced the SQL, and the parse, execute and fetch all appear to succeed. | | | If I cut and paste the output, it works exactly as it should but not when run from the stored procedure. | | | I've changed the command to various other DDL statements and it works as expected. |
|
http://www.ixora.com.au/q+a/plsql.htm
(933 words)
|
|
| |
| | SQL, SQL*Plus, and PL/SQL Standards |
| | The Oracle userid and password will be an environment variable in the UNIX script and accepted into the program. | | | Use the NVL function to avoid null values where necessary. | | | Declare a variable as a constant if the value of the variable will not change throughout the program. |
|
http://www.nd.edu/~ndora/standard/sql.html
(1507 words)
|
|
| |
| | PL/SQL help and tutorial |
| | These objects are used to store and manipulate block level data. | | | Ifs, Loops, GOTOs and labels provide conditional actions, tests, branching and iterative program control. | | | As a minimum there must be the delimiting words BEGIN and END around the executable statements. |
|
http://www.ilook.fsnet.co.uk/ora_sql/sqlplus03.htm
(502 words)
|
|
| |
| | O'Reilly Network: Using PL/SQL Records in SQL Statements |
| | In the bulk syntax case, you can't reference fields of the in-bind table of records elsewhere in the SQL statement (especially in the | | | In response to developer requests, Oracle has now made it possible for us to do any of the following with static SQL (such as, SQL statements that are fully specified at the time your code is compiled): | | | This capability, while available for many years, was limited in its usefulness because it wasn't possible to use records inside SQL statements. |
|
http://www.oreillynet.com/pub/a/network/2003/04/22/feuerstein.html
(1366 words)
|
|
| |
| | oreilly.com -- Online Catalog: Steven Feuerstein |
| | It covers coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. | | | Oracle PL/SQL Best Practices is a concise, easy-to-use summary of best practices in the program development process. | | | Updated for Oracle10g, it includes fundamental language elements; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL; new Oracle 10g elements, and much more. |
|
http://www.oreillynet.com/cs/catalog/view/au/344
(808 words)
|
|
| |
| | Oracle/SQL Tutorial |
| | This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. | | | This version then will include Oracle9i features and a section on query optimization. | | | PL/SQL (Loops and Cusors), Embedded SQL and Pro*C |
|
http://sirius.cs.ucdavis.edu/teaching/sqltutorial
(120 words)
|
|
| |
| | Amazon.co.uk: Books: Oracle PL/SQL Programming |
| | Subjects > Computers & Internet > Databases > Oracle > PL & SQL | | | The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. | | | If you know SQL, but want to learn PL/SQL, bypass the Learning Oracle PL/SQL book and dive into this on. |
|
http://www.amazon.co.uk/exec/obidos/ASIN/1565923359
(886 words)
|
|
| |
| | Catching error code that arises in PL/SQL |
| | But, if you're using this as an example of a value a user might type in and then get passed into the call to to_date, I'd suggest that you'd need code some data validation checks on the values the user is entering before passing to the function. | | | Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions. | | | SQL> / Enter value for user_input_value: 234w You must enter a valid date in MMYY format. |
|
http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid536743_tax294551,00.html
(411 words)
|
|
| |
| | Amazon.com: Books: Oracle PL/SQL Programming |
| | Subjects > Computers & Internet > Databases > Specific Databases > Oracle > Databases > PL & SQL | | | Subjects > Computers & Internet > Databases > Specific Databases > SQL > General | | | Customers interested in Oracle PL/SQL Programming may also be interested in |
|
http://www.amazon.com/exec/obidos/tg/detail/-/1565923359?v=glance
(1416 words)
|
|
| |
| | Oracle 8i PL/SQL: Advanced SQL |
| | The title Oracle8i PL/SQL: Advanced SQL, SQL *Plus, and the Data Dictionary provides the learner with the basic concepts and skills required to create sub queries and queries using SET operators. | | | The title describes the SQL *Plus file commands and SET commands that are used to customize the SQL *Plus environment. | | | Furthermore, the title discusses the SQL *Plus format commands and script files. |
|
http://www.tutorials.com/catalog/catalog_item_n.asp?ugid=dHV0b3JpYWxz&pid=1526&csid=754
(106 words)
|
|
| |
| | Opensoft,Inc. - SQL Debugger |
| | Results – each query result will be putting in a seperated grid view for easy browse on screen. | | | The input vaule can be easily enter in the cell. | | | Making the code easy to be read and keyword typo easy to be identified. |
|
http://www.opensoftinc.com/joraclepro1.0/osi_joraclepro.html
(355 words)
|
|
| |
| | PL/SQL Sample Code |
| | Invoker-Rights programs execute with the privileges of the user invoking the program. | | | Before Oracle8i, support for Dynamic SQL in PL/SQL is available through the DBMS_SQL package's programmatic interfaces. | | | Native Dynamic SQL in PL/SQL makes dynamic SQL processing in PL/SQL extremely simple and easy to use. |
|
http://www.oracle.com/technology/sample_code/tech/pl_sql
(632 words)
|
|
| |
| | Visual Studio Magazine - First Looks - Troubleshoot PL/SQL |
| | You can step through your PL/SQL to examine both flow of execution and variable values until you find all problems—a big improvement over running the function and examining its results until the problem becomes apparent. | | | DevPartnerDB also color codes SQL keywords and letters and displays a variable's value when you hover over it with the cursor. | | | He's an MCSD and JCP with extensive Oracle and SQL Server experience. |
|
http://www.fawcette.com/vsm/2003_02/magazine/departments/firstlooks
(462 words)
|
|
| |
| | PL/SQL Programming |
| | PL/SQL stands for Procedural Language extension of SQL. | | | Functions can be used within SQL statements only in version 2.1 and higher. | | | However, your_var is only visible to the sub-block, since its scope is from the DECLARE to the first END statement. |
|
http://www.uidaho.edu/developers/articles/plsql.html
(3084 words)
|
|
| |
| | LOG4PLSQL : Oracle Database Logging tools |
| | Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools. | | | Tora Integration: TOra is a Toolkit for Oracle which aims to help the DBA or developer of database application. | | | To talk about log4plsql use log4plsql-all-info mailing list |
|
http://log4plsql.sourceforge.net
(131 words)
|
|
| |
| | PL/SQL Web Toolkit Reference |
| | The purposes of these range from printing a signature tag on HTML pages to retrieving the values of CGI environment variables and performing URL redirects. | | | These enable you to produce Web pages with dynamically generated SQL code. | | | These make it easier to properly handle dates, which are simple strings in HTML, but are properly treated as a datatype by the Oracle RDBMS. |
|
http://kontti.helsinki.fi:8889/ows-adoc/psqlwtlk.htm
(398 words)
|
|
| |
| | SQL and PL/SQL Syntax and Examples |
| | You can view the definition of the keyword, or search for code examples that use it. | | | These keywords include statements, functions, built-in packages and procedures, and some SQL clauses. | | | Choose a letter to see all of the SQL and PL/SQL keywords that start with that letter. |
|
http://tahiti.oracle.com/pls/tahiti/tahiti.sql_keywords
(46 words)
|
|
| |
| | Oracle Programming with PL/SQL Collections |
| | PL/SQL applications typically consist of SQL statements intermixed with procedural logic to process data retreived from the database. | | | Not only that, programs that continually switch off between code and SQL can become quite complex. | | | Having said that, anytime a software application links up with a database, there is a performance price to be paid. |
|
http://www.developer.com/db/article.php/3379271
(696 words)
|
|
| |
| | PL/SQL help and tutorial |
| | Programming Language/SQL (PL/SQL) is an Oracle extension of the SQL statement set which allows the developer to impose flow control and logic design onto unstructured SQL command blocks. |
|
http://www.ilook.fsnet.co.uk/ora_sql/sqlmain2.htm
(28 words)
|
|
| |
| | Refactoring PL/SQL |
| | this sql may be embedded in jdbc call's or in pl/sql... | | | 1) refactoring java usually doesn't impact production data, but when refactoring sql you have to think about migrating data, which usually means creating a lot of migration scripts. | | | there java and pl/sql are more or less equal: simply a host language for sql. |
|
http://weblog.cemper.com/a/200311/13-refactoring-plsql.php
(362 words)
|
|
| |
| | Download KeepTool Oracle Databases test Hora ER Diagrammer, PL/SQL-Debugger |
| | After 30 days of testing, you must either purchase a license or delete the software completely from your computer. | | | The Exe file (approximately 10 MB) installs the executable for HoraLight. | | | The Exe file (approximately 13 MB) installs executables for Hora (including SQL Editor, HTML Generator, and Reverse DDL Engineer), ER Diagrammer, and PL/SQL Debugger. |
|
http://www.keeptool.de/en/download.php
(93 words)
|
|
| |
| | Know Dot Net - Creating Packages with PL/SQL |
| | I was lucky enough to get to work with an Oracle 7.0 database at the beginning of my career and then moved on to an 8i database. | | | A short time afterward, I went to work in an environment where I used SQL Server exclusively. | | | Truth be told, propertly implementation of E.F. Codd's brilliant work matter a whole lot more than the RDBMS that you store data in. |
|
http://www.knowdotnet.com/articles/packages.html
(457 words)
|
|
| |
| | PL/SQL Technology Center |
| | PL/SQL is Oracle's procedural extension to industry-standard SQL. | | | Its primary strength is in providing a server-side, stored procedural language that is easy-to-use, seamless with SQL, robust, portable, and secure. | | | Thus, it offers a platform for robust, high-performing enterprise applications, not only for our Fortune 500 customers, but also for Oracle Applications, which have over 4 million lines of code. |
|
http://www.oracle.com/technology/tech/pl_sql
(170 words)
|
|
| |
| | iSelfSchooling - Manuscripts for SQL and PL/SQL |
| | 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. | | | 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 SQL*PLUS stores the most recently executed SQL statement. |
|
http://www.iselfschooling.com/iss4sqlplsql.htm
(695 words)
|
|
| |
| | PL/SQL |
| | This command must be executed to activate the internal buffer that displays program output. | | | SQL> SET SERVEROUPUT ON SIZE buffer_size; (typical = 4000) | | | Single line comments begin with two hyphens -- |
|
http://cs-netlab-01.lynchburg.edu/courses/Oracle/PLSQL.htm
(288 words)
|
|
| |
| | Index on PL/SQL items (JL Comp) |
| | Executing dynamic sql in packages as User, not Owner in in v7 | | | Turning a PL/SQL table into an SQL statement (v8) | | | My page on things you can do with PL/SQL - and probably some comments about things you shouldn't do with PL/SQL. |
|
http://www.jlcomp.demon.co.uk/ind_plsql.html
(121 words)
|
|
| |
| | Discussion Forums : SQL and PL/SQL |
| | Using if the else logic in regards to a select statement for a report | | | Discussion Forums » Database » SQL and PL/SQL |
|
http://forums.oracle.com/forums/forum.jsp?forum=75
(67 words)
|
|
|
