| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 MDX tutorial, introduction | Other | Beginner /
Kamil_Moscicki | 4798 since
5/14/2012 4:47:02 PM | Unrated
|
| |
MDX is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas. Tutorial presents introduction to MDX (MultiDimensional Expressions) wi ...(description truncated) (ScreenShot) |
| |
| |
| |
|
 Paging in SQL Server | Other | Beginner /
Developer142 | 1837 since
5/14/2012 4:45:06 PM | Unrated
|
| |
Paging in SQL Server |
| |
| |
| |
|
MongoDB tutorial, introduction | Other | Beginner /
Kamil_Moscicki | 1586 since
5/14/2012 4:42:09 PM | Unrated
|
| |
MongoDB is an open source NoSQL database system. Tutorial presents introduction to MongoDB and describes how to use document-oriented database system: how to insert, select, update and delete data, use Set and Unset operators. If you want to watch video l ...(description truncated)(ScreenShot) |
| |
| |
| |
 |
 UTL_FILE file utility - copy a flat file from your PC's hard drive to Unix | Oracle | Advanced /
Andy Archer | 1892 since
5/14/2012 4:42:06 PM |
By 1 Users
|
| |
Via your PC. UTL_FILE gets a lot of help on this one. A Windows CMD (command line) BAT file, SQL*Plus, PL/SQL, SQL*Loader ...each plays a part.(ScreenShot) |
| |
| |
| |
|
 Oracle tutorial, introduction to PL/SQL | Oracle | Beginner /
Kamil_Moscicki | 7883 since
4/19/2012 4:08:13 PM | Unrated
|
| |
Oracle PL/SQL tutorial presents basic and more advanced aspects of programming in PL/SQL. Tutorial focuses on practical examples and pays attention to key issues. Free lessons present how to use anonymous blocks, declare variables, use conditional and ite ...(description truncated)(ScreenShot) |
| |
| |
| |
|
UTL_FILE file utility - copy a flat file from Unix to your PC's hard drive | Oracle | Advanced /
Andy Archer | 1852 since
3/23/2012 4:33:28 PM | Unrated
|
| |
Via your PC's SQL*Plus session, this script jumps through a few hoops to get the job done. PL/SQL, staging table, UTL_FILE, SPOOL ...they're all here. Thank goodness for TRIMSPOOL!(ScreenShot) |
| |
| |
| |
|
UTL_FILE file utility - make a CSV Unix flat file from a table, using a FOR loop | Oracle | Intermediate /
Andy Archer | 2096 since
3/19/2012 2:40:49 PM | Unrated
|
| |
This is a nice structured example PL/SQL stored procedure. A comma-separated value (CSV) Unix flat file is created from a table. A FOR loop is utilized instead of fetching from a cursor. |
| |
| |
| |
|
freeze your PL/SQL's execution until a condition has been met | Oracle | Intermediate /
Andy Archer | 1606 since
2/29/2012 5:28:11 PM | Unrated
|
| |
This block illustrates a technique for putting your PL/SQL's execution into "suspended animation" until a condition has been met. The technique involves a loop, counter, and DBMS_LOCK.SLEEP ...all wrapped around the condition check. |
| |
| |
| |
|
Split String Plus | Oracle | Advanced /
Andy Archer | 1448 since
2/16/2012 4:23:03 PM | Unrated
|
| |
The by_delim function in this PL/SQL stored package returns in_string's delimited pieces as array elements, either in normal sequence or (by way of additional algorithms) backwards or in an ascending or descending order. With SQL*Plus test script. |
| |
| |
| |
|
see instance name in your SQL*Plus prompt (five methods) | Oracle | Intermediate /
Andy Archer | 5156 since
2/15/2012 10:33:01 AM | Unrated
|
| |
Here are five ways to display instance name in your SQL*Plus prompt. Edit the GLOGIN.SQL or LOGIN.SQL files on your PC to include one of the code snippets. Lets you know where you are. |
| |
(ScreenShot)
(ScreenShot)
(ScreenShot)
(ScreenShot)
(ScreenShot)
