Oracle SQLPlus [Electronic resources] : The Definitive Guide, 2nd Edition

Jonathan Gennick

نسخه متنی -صفحه : 151/ 135
نمايش فراداده

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] failure codes

passing back to shell scripts FAILURE option WHENEVER OSERROR command

WHENEVER SQLERROR command FAILURE parameter EXIT command

QUIT command

FEED[BACK] setting

2nd

spooling data to file

feedback, turning off

filename extension, default files data output files, types of

2nd

DDL files

delimited files

fixed-width files

default extension for command files

global login

glogin.sql script (site profile)

login.sql script

sending report output to

spool,timestamping

spooling data to

SQL*Loader control file

startup scripts

FILTER operation (EXPLAIN PLAN)

FIRST ROW operation (EXPLAIN PLAN)

FLAGGER setting

FLOAT datatype

FLU[SH] setting

FOLD_A[FTER] parameter (COLUMN command)

FOLD_B[EFORE] parameter (COLUMN command)

font size for reports footers and headers bottom title

HTML reports

report pages

2nd

reports, print once

system variables for defining

top title

FOR UPDATE operation (EXPLAIN PLAN) FOR[MAT] clause ACCEPT command

ATTRIBUTE command

COLUMN command

REPHEADER, REPFOOTER commands

2nd

TTITLE command

FORCE parameter (STARTUP)

foreign key constraints

format specification, defined formatting character strings

columns

columns in reports

data

date elements for

date examples

LONG column lengths

master/detail reports

numbers

PRINT command output

report pages

word wrap

2nd

3rd

formulating queries

forward slash (/), executing SQL buffer

FULL hint

FULL parameter (SET FLAGGER) functions aggregate

datatypes, viewing