Oracle SQL*Plus^TM Commands - A

Under construction

Use this command to accept input from a user.

ACC[EPT] user_variable [NUM[BER] | CHAR | DATE ]

    [FOR[MAT] format_specification]

    [DEF[AULT] default_value]

    [PROMPT prompt_text | NOPR[OMPT]]

    [HIDE]

Back to top

Use this command to append text to the end of the current line in the SQL buffer. If you want this text to start with a space, you need to start it with two spaces.

A[PPEND] text

Back to top

Use this command to control archive logging, or to display information about it. You must first connect to SYSDBA, SYSOPER or INTERNAL.

ARCHIVE LOG {LIST |

              STOP |

              START [TO destination] |

              NEXT [TO destination] |

              ALL [TO destination] |

              log_sequence_number [TO destination] }

Back to top

Use this command to format attributes of an Oracle8 object type.

ATTRIBUTE [object_type.attribute |

              attribute_alias

              [ALI[AS] alias | CLE[AR] |

              FOR[MAT] format_spec |

              LIKE source_attribute |

              ON | OFF...]]

Back to top     Back to Index     Home     Serious Stuff

© 2001. Copyright Sue Nethercott.