📄 file_index.html
字号:
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<title>Oracle PL/SQL Programming Supplemental Files</title>
</head>
<body lang=EN-US bgcolor="#FFFFFF">
<table border=1 cellspacing=0 cellpadding=0>
<tr>
<td bgcolor="#000000">
<p><b><FONT color="#FFFFFF">File Name</FONT></b>
</td>
<td bgcolor="#000000">
<p><b><FONT color="#FFFFFF">Chapter</FONT></b>
</td>
<td bgcolor="#000000">
<p><b><FONT color="#FFFFFF">Description</FONT></b>
</td>
</tr>
<tr>
<td>
<p>daternge.sf</p>
</td>
<td> WEB </td>
<td>
<p>Generates a date range string to append to SQL statements </p>
</td>
</tr>
<tr>
<td>
<p><a href="ftp://elsie.nci.nih.gov/pub/ ">ftp://elsie.nci.nih.gov/pub/</a>
</td>
<td> </td>
<td>
<p> The source for the time zone region definitions that Oracle uses. Look
particularly at tzdata2002c.tar.gz.
</td>
</tr>
<tr>
<td>
<p> insert_books.sql
</td>
<td>
<p> 2+
</td>
<td>
<p> Insert various rows into the books table
</td>
</tr>
<tr>
<td>
<p> bulktiming.sql
</td>
<td>
<p> 1
</td>
<td>
<p> Performs timing comparisons between bulk processing (FORALL and BULK
COLLECT) and row-by-row processing
</td>
</tr>
<tr>
<td>
<p> oneversion.sql
</td>
<td>
<p> 1
</td>
<td>
<p> Demonstration of a technique using SQL*Plus substitution parameters
for maintaining multiple sets of code in a single file
</td>
</tr>
<tr>
<td>
<p> books.tab
</td>
<td>
<p> 2
</td>
<td>
<p> CREATE TABLE statement for books table used in Chapter 2.
</td>
</tr>
<tr>
<td>
<p> booktitle.fun
</td>
<td>
<p> 2
</td>
<td>
<p> Function that retrieves a book抯 title by its ISBN.
</td>
</tr>
<tr>
<td>
<p> callbooktitle.java
</td>
<td>
<p> 2
</td>
<td>
<p> Java version of program that calls the PL/SQL booktitle function.
</td>
</tr>
<tr>
<td>
<p> callbooktitle.pc
</td>
<td>
<p> 2
</td>
<td>
<p> Pro*C version of program that calls the PL/SQL booktitle function.
</td>
</tr>
<tr>
<td>
<p> callbooktitle.pl
</td>
<td>
<p> 2
</td>
<td>
<p> Perl version of program that calls the PL/SQL booktitle function.
</td>
</tr>
<tr>
<td>
<p> favorite_plsql_book.psp
</td>
<td>
<p> 2
</td>
<td>
<p> PL/SQL Server Pages version of program that calls the PL/SQL booktitle
function.
</td>
</tr>
<tr>
<td>
<p> reserved.txt
</td>
<td>
<p> 2
</td>
<td>
<p> Absolute minimal list of words to avoid using as PL/SQL identifiers
</td>
</tr>
<tr>
<td>
<p> wordcount.fun
</td>
<td>
<p> 2
</td>
<td>
<p> Function to count the number of words in an input string
</td>
</tr>
<tr>
<td>
<p> README_vim.txt
</td>
<td>
<p> 3
</td>
<td>
<p> Instructions for setting up the free "vim" editor with support
for PL/SQL syntax highlighting and automatic indentation
</td>
</tr>
<tr>
<td>
<p> ch04_case01.sql
</td>
<td>
<p> 4
</td>
<td>
<p> Simple CASE statement solution to the bonus problem.
</td>
</tr>
<tr>
<td>
<p> ch04_case02.sql
</td>
<td>
<p> 4
</td>
<td>
<p> Searched CASE solution to the bonus problem.
</td>
</tr>
<tr>
<td>
<p> ch04_case03.sql
</td>
<td>
<p> 4
</td>
<td>
<p> Simple CASE expression example, using boolean_to_varchar2.
</td>
</tr>
<tr>
<td>
<p> ch04_case04.sql
</td>
<td>
<p> 4
</td>
<td>
<p> Searched CASE expression solution to bonus problem.
</td>
</tr>
<tr>
<td>
<p> ch04_if01.sql
</td>
<td>
<p> 4
</td>
<td>
<p> IF-THEN-ELSIF example using the BETWEEN predicate, and demonstrating
what happens when both an IF and an ELSIF evaluate to true.
</td>
</tr>
<tr>
<td>
<p> ch04_if02.sql
</td>
<td>
<p> 4
</td>
<td>
<p> Same as ch04_if01.sql, but eliminates the overlap between conditions.
</td>
</tr>
<tr>
<td>
<p> ch04_if03.sql
</td>
<td>
<p> 4
</td>
<td>
<p>Demonstrates the effects of NULLs in IF⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -