| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 UTL_FILE file utility - make a PC file from similar variable-length strings in a Unix flat file | Oracle | Advanced /
Andy Archer | 5316 since
9/19/2012 9:40:53 AM | Unrated
|
| |
Via this SQL*Plus script, you can isolate and embellish similar strings of varying lengths from a Unix flat file. The script contains a PL/SQL block that utilizes EXECUTE IMMEDIATE, UTL_FILE, and the INSTR built-in. |
| |
| |
| |
|
find server PL/SQL source code | Oracle | Intermediate /
Andy Archer | 4974 since
9/19/2012 9:40:11 AM |
By 1 Users
|
| |
This script solicits a user PL/SQL object name and type at the SQL*Plus prompt, runs SQL to find the object's Data Dictionary source code, spools the results to a file, and opens the file in Notepad. For any server-side proc or trigger. |
| |
| |
| |
|
UTL_FILE file utility - make a PC file of Insert statements from a Unix flat file's delimited fields | Oracle | Advanced /
Andy Archer | 6244 since
9/19/2012 9:40:09 AM | Unrated
|
| |
This SQL*Plus script is handy for quickly adding lots of rows to a validation table. The script contains a PL/SQL block that utilizes EXECUTE IMMEDIATE, UTL_FILE, and a parsing function. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
find a particular character in a column | Oracle | Intermediate /
Andy Archer | 6667 since
9/7/2012 4:51:37 PM |
By 1 Users
|
| |
This example PL/SQL cursor uses the TRANSLATE built-in to find rows in a table that have a special character (from the set specified in the TRANSLATE) in one or more of their varchar2 columns. No looping required. |
| |
| |
| |
|
eight SQL*Plus tips | Oracle | Beginner /
Andy Archer | 9411 since
9/4/2012 3:10:51 PM |
By 3 Users
2 Excellent Ratings
|
| |
A short write-up: suppress "Input truncated" and SET echoing; see full text of DBMS_OUTPUT and LONG Selects; execute scripts with shorthand; edit session profile; save and reapply settings; see leading spaces on DBMS_OUTPUT. |
| |
| |
| |
 |
 Top Clause - Simplified | Other | Advanced /
Dinesh Mishra | 6707 since
8/1/2012 4:29:34 PM | Unrated
|
| |
Use of 'Top' Clause:
================
Many a times we are faced with situation wherein we want the say top 2 or top 5 of values in ascending or descending format from a table. An example of it is requirement from sales department wherein the top 2 sales i ...(description truncated) |
| |
| |
| |
|
Retrieving the Bottom-N Rows | SQL Server 2000, Other | Advanced /
Rajib Chowdhury | 3235 since
6/21/2012 3:18:34 PM | Unrated
|
| |
This PL/SQL stored procedure Retrieving the Bottom-N Rows from a SQL Table
|
| |
| |
| |
|
Find Initial in SQL | SQL Server 2000 | Advanced /
Rajib Chowdhury | 1953 since
6/19/2012 5:14:44 PM |
By 1 Users
|
| |
A Procedure that will accept a string and give its initial as output. |
| |
| |
| |
|
Add Hours Or Days Or Weeks Or Months Or Years | Oracle | Intermediate /
Andy Archer | 11442 since
6/14/2012 5:18:22 PM | Unrated
|
| |
Using simple Oracle date functionality, this PL/SQL stored function adds the specified number of hours, days, weeks, months, or years to the IN date and time, returning the new date and time. With SQL*Plus test script. |
| |
| |
| |
|
 Summarizing data type/propertywise with SQL. | SQL Server 2000, Other | Advanced /
Dinesh Mishra | 1602 since
6/4/2012 3:27:05 PM | Unrated
|
| |
Summary of records with 'WITH CUBE':
----------------------------------------------------------
We are always faced with situations wherein we have to summarize the data to be presented. Suppose you have item of different types and different colours and y ...(description truncated) |
| |
