[PDF] Database PL/SQL Language Reference

View - Download Database PL/SQL Language Reference

Previous PDF

Next PDF

boldfaceBoldface type indicates graphical user interface elements associated with an

action, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables for which

you supply particular values. Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.{A|B|C}Choose either A, B, or C.

Lets PL/SQL blocks, subprograms,

packages, and triggers display output.

Especially useful for displaying PL/SQL

debugging information.Oracle Database PL/SQL

Packages and Types

Reference

Has hypertext functions that generate

HTML tags (for example, the

function generates the HTML anchor tag

Oracle Database PL/SQL

Packages and Types

Reference

Has hypertext procedures that generate

HTML tags.Oracle Database PL/SQL

Packages and Types

Reference

Lets two or more sessions in the same

instance communicate.Oracle Database PL/SQL

Packages and Types

Reference

Lets PL/SQL programs read and write

operating system files.Oracle Database PL/SQL

Packages and Types

Reference

Lets PL/SQL programs make Hypertext

Transfer Protocol (HTTP) callouts, and

access data on the Internet over HTTP.Oracle Database PL/SQL

Packages and Types

Reference

Sends electronic mails (emails) over

Simple Mail Transfer Protocol (SMTP) as

specified by RFC821.Oracle Database PL/SQL

Packages and Types

Reference

Controls the compile-time collection, cross-reference, and storage of PL/SQL source text identifier data. Used by the PL/ Scope tool (see Oracle Database Development Guide).

For more information about

, see Oracle

Database Reference.

Lets you control conditional compilation of each PL/SQL unit independently.

For more information about

, see " " and Oracle Database

Reference.

Specifies the compilation mode for PL/SQL unitsÐ (the default) or . For information about which mode to use, see "

If the optimization level (set by

) is less than 2: ·The compiler generates interpreted code, regardless of

·If you specify

, the compiler warns you that was ignored.

For more information about

, see Oracle

Database Reference.

Specifies the optimization level at which to compile PL/SQL units (the higher the level, the more optimizations the compiler tries to make). instructs the PL/SQL compiler to generate and store code for use by the PL/SQL debugger.

For more information about

, see "" and Oracle Database Reference. Enables or disables the reporting of warning messages by the PL/SQL compiler, and specifies which warning messages to show as errors.

For more information about

, see " " and Oracle Database Reference.

Lets you create

and columns using either byte- length or character-length semantics. For more information about byte and character length semantics, see "".

For more information about

, see

Oracle Database Reference.

Specifies whether the 12.1 PL/SQL compiler can use wrapped packages that were compiled with the 9.2 PL/SQL compiler. The default value is

For more information about wrapped packages, see

For more information about

, see

Oracle Database Reference.

Left parenthesis

Right parenthesis

Left angle bracket

Right angle bracket

Plus sign

Hyphen or minus sign

Asterisk

Slash

Equal sign

Comma

Semicolon

Colon

Period

Exclamation point

Question mark

Apostrophe or single quotation mark"Quotation mark or double quotation mark

At sign

Percent sign

Number sign

Dollar sign

Underscore

Vertical bar

Addition operator

Assignment operator

Association operator

Attribute indicator

Character string delimiter

Component indicator

Concatenation operator

Division operator

Exponentiation operator

Expression or list delimiter (begin)

Expression or list delimiter (end)

Host variable indicator

Item separator

Label delimiter (begin)

Label delimiter (end)

Multiline comment delimiter (begin)

Multiline comment delimiter (end)

Multiplication operator

Quoted identifier delimiter

Range operator

Relational operator (equal)

Relational operator (not equal)

Relational operator (not equal)

Relational operator (not equal)

Relational operator (not equal)

Relational operator (less than)

Relational operator (greater than)

Relational operator (less than or equal)

Relational operator (greater than or equal)

Remote access indicator

Single-line comment indicator

Statement terminator

Subtraction or negation operator

autonomous_trans_pragma coverage_pragma deprecate_pragma exception_init_pragma inline_pragma restrict_references_pragma serially_reusable_pragma suppresses_warning_6009_pragma udf_pragma exponentiation identity, negation multiplication, division addition, subtraction, concatenation comparison negation conjunction inclusion equal to not equal to less than greater than less than or equal to greater than or equal to ()Expression delimiter**exponentiation*, /,+, -Arithmetic operators for multiplication, division,

addition or positive, subtraction or negative=, !=, <, <=, >=, > IS [NOT] NULLComparison operatorsNOTLogical operator[NOT] LIKE, [NOT] LIKE2, [NOT] LIKE4, [NOT]

LIKECPattern matching operatorsXORBinary operator

32,767 bytes2,000 bytes

32,767 bytes2,000 bytes

32,767 bytes2,000 bytes

32,767 bytes4,000 bytes

32,767 bytes4,000 bytes

32,760 bytes2 gigabytes (GB) - 1

32,760 bytes2 GB

128 terabytes (TB)(4 GB - 1) *

128 TB(4 GB - 1) *

128 TB(4 GB - 1) *

value for which the condition (not a number) is true (*)Single-precision positive infinity

Maximum normal

value

Minimum normal

value

Maximum subnormal

value

Minimum subnormal

value value for which the condition (not a number) is true (*)Double-precision positive infinity

Maximum normal

value

Minimum normal

value

Maximum subnormal

valuequotesdbs_dbs14.pdfusesText_20

[PDF] oracle acs

[PDF] oracle acs pricing

[PDF] oracle acs review

[PDF] oracle acs vs ocs

[PDF] oracle advanced customer services

[PDF] oracle advanced pl sql tutorial pdf

[PDF] oracle advanced support gateway documentation

[PDF] oracle amr support

[PDF] oracle apex 19 manual

[PDF] oracle apex 19.1 architecture

[PDF] oracle apex 19.1 tutorial

[PDF] oracle apex 19.1 tutorial for beginners

[PDF] oracle apex 19.1 tutorial pdf

[PDF] oracle apex 19.2 download

[PDF] oracle apex 19.2 installation