Oracle SQL*Plus^TM Commands - C

Under construction

Use this command to search and replace in the current line in the SQL buffer, or to delete text.

C[HANGE] /old_text[/[new_text[/]]

Back to top

Use this command to delete all column definitions, break settings, computer definitions etc.

CL[EAR]{BRE[AKS] | BUFF[ER] | COL[UMNS] | COMP[UTES] | SCR[EEN] | SQL | TIMI[NG]}

Back to top

Use this command to format columnar reports. To get a list of all current column formats, use the COLUMN command without parameters.

              CLE[AR] | FOLD_A[FTER] | FOLD_B[EFORE] |

              FOR[MAT] format_spec | HEA[DING] heading_text |

              JUS[TIFY] {LEFT | CENTER | CENTRE | RIGHT] |

              LIKE source_column_name | NEWL[INE] |

              NEW_V[ALUE] user_variable | NOPRI[NT] |

              PRI[NT] | NUL[L] null_text |

              OLD_V[ALUE] user_variable | ON | OFF |

              TRU[NCATED] | WOR[D_WRAPPED] | WRA[PPED]...]]

Back to top

Use this command to define summary calculations that you need in a report. You can use COMPUTE in conjunction with the BREAK command. To obtain a list of all currently defined computations, use COMPUTE without parameters.

COMP[UTE] [{AVG | COU[NT] | MAX[IMUM] |

              MIN[IMUM] | NUM[BER] | STD | SUM | VAR[IANCE]}...

              OF column_name...

              ON {group_column_name | ROW | REPORT}...]

Back to top

Use this command to change your database connection, log in as a different user, or connect to the database in an administrative mode.

CONN[ECT] [username[/password][@connect] | / ]

              [AS {SYSOPER | SYSDBA}] | [INTERNAL]

Back to top

Use this command to transfer data between 2 Oracle databases.

COPY {FROM connection | TO connection}

              {APPEND | CREATE | INSERT | REPLACE}

              destination_table [(column_list)]

              USING select_statement

Back to top     Back to Index     Home     Serious Stuff

© 2001. Copyright Sue Nethercott.