NEWS: >> Fast Guide: PL/SQL (SearchOracle.com) 07 Jun 2004 ADVICE: >> Defense tactics for SQL injection attacks TIP :The rate of application intrusions continues to rise, and many result from SQL injection attacks. Fortunately, SQL injection ... >> Oracle SQL and index internals: Histograms and finding the poorly running SQL TIP :The following is the final part of a 12-part series on Oracle10g CBO internals and SQL tuning optimization. >> SQL generation vs. Oracle stored procedures TIP :An ITKnowledge Exchange member had a question about which option to choose: SQL generation or stored procedures. Fellow ... >> Paging through SQL query results ASK THE EXPERTS :What is the best way to do pagination on SQL query results? I used LIMIT M,N in MySQL. Is there something like that in SQL? >> ISO/ANSI SQL and the GROUP BY clause ASK THE EXPERTS : I'm trying to figure out what is ISO/ANSI SQL:1999 approved usage for the "group by" statement in terms of the SQL:1999 ... >> Error message while trying to write a Pl/SQL block ASK THE EXPERTS : I have gotten this message, ?ERROR at line 1: ORA-03114: not connected to Oracle.? I'm trying to write a Pl/SQL block. What ... >> Oracle SQL tuning secrets WEBCASTS :In this webcast, Don Burleson will teach attendees how to focus on real-world techniques for improving the speed of SQL ... WHITE PAPERS: >> Book excerpt series: Oracle SQL and index internals >> Oracle Database 10g SQL (Chapter 5) >> Oracle SQL and PL/SQL - Development and maintenance concepts

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle SQL SQL to count values of a status code Counting NULL columns Detail rows for accounts that occur three times Counting a row's NULL columns Oracle's free SQL Developer adds database migration tool Latest transaction if no recent prior transactions Three ways SQL can count rows by type SQL to select only certain times within a date range Oracle SQL to test for numerics Number of rows in multiple tables Oracle SQL Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary autonomous transaction  (SearchOracle.com) CFML  (SearchOracle.com) dynamic SQL  (SearchOracle.com) foreign key  (SearchOracle.com) Java Database Connectivity  (SearchOracle.com) Open Database Connectivity  (SearchOracle.com) Oracle  (SearchOracle.com) stored procedure  (SearchOracle.com) The Open Group  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary