 |
| ADVICE: |
| >> |
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 ... |
| >> |
Learning Oracle PL/SQL: What, when, and where
TIP :What the Procedural Language/Structured Query Language (PL/SQL) really is, what it is good for, and how it fits into the ... |
| >> |
PL/SQL control structures: Best practices
TIP :Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in ... |
| >> |
Improving PL/SQL performance by using collections
TIP :Plus Consultancy's Mark Rittman outlines how PL/SQL has changed in different Oracle versions and explains how to use ... |
| >> |
Check all active processes, the latest SQL, and the SQL hit ratio
TIP :When your Oracle server becomes slow, use this SQL to find out all ACTIVE connections with hit ratio and SQL. |
| >> |
SQL vs. PL/SQL
ASK THE EXPERTS :Can you please tell me what is wrong in the procedure below? A solution would be appreciated.
DECLARE
... |
| >> |
PL/SQL control structures: Best practices
TIP :Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in ... |
| >> |
Learning Oracle PL/SQL: What, when, and where
TIP :What the Procedural Language/Structured Query Language (PL/SQL) really is, what it is good for, and how it fits into the ... |
| >> |
Analytical processing with Oracle SQL
TIP :This chapter from the book "Oracle SQL & PL/SQL Handbook" will show you how analytic functions like ROLLUP and CUBE are ... |
| >> |
Using PL/SQL to read delimited ASCII text files into tables
ASK THE EXPERTS :I have an ASCII text file delimited by "|" characters. What is the best of reading these records into tables using PL/SQL? |
| >> |
Returning more than one value from PL/SQL procedure
ASK THE EXPERTS :Is it possible to return more than one value from a PL/SQL procedure or function? If so, how would I go about it? |
| >> |
Running SQL*Loader from within PL/SQL procedure
ASK THE EXPERTS :On a Unix system, is there any way to run SQL*Loader from within a PL/SQL procedure or package? I need variables like the ... |
| >> |
Calling a PL/SQL procedure or function from a Java program
ASK THE EXPERTS :Can you call a PL/SQL procedure or function from a Java
program, returning error code, messages and answer? |
| >> |
PL/SQL UTL_SMTP procedure to send e-mail
ASK THE EXPERTS :I'm trying to use PL/SQL utl_smtp. When I run the procedure, I get a
message
that says that it was successfully ... |
| >> |
Truncate tables using PL/SQL
TIP :This tip truncates data from tables using PL/SQL for Oracle8i. |
| >> |
Adding profits for each fish type with PL/SQL
ASK THE EXPERTS :Using PL/SQL, I have a few tasks, and rather than further struggle through it, I'd rather see if you can help and then study ... |
| >> |
Using dblink when defining cursor in PL/SQL routine
ASK THE EXPERTS :Is it possible to use a database link when defining a cursor in a PL/SQL routine? We are looking to run a statement against ... |
| >> |
Using dynamic SQL
ASK THE EXPERTS :How do you use dynamic SQL, and what is a typical use of dynamic SQL?
Also, what are the steps you use and how is DBMS ... |
| >> |
Build a servlet-based application that executes SQL statements against a database
TIP :How to use a Java servlet, JSP, and a static Java class to interactively execute any standard SQL statement against a ... |
| >> |
PL/SQL script to get PLAN of running SQL
TIP :This PL/SQL script provides the PLAN for SQL currently running by providing the SID and serial number for a session. |
| >> |
Picking the first 25 characters in SQL
ASK THE EXPERTS :The column in database is a varchar(25). But sometimes my datafile has data for this column exceeding 25. I want the ... |
