Oracle sqlplus command line tools does not support command line editing out-of-the-box. But on Linux there's a handy utility that enables command line editing with any command line tool: rlwrap - readline wrapper. Install rlwrap: $ sudo apt-get install rlwrap Create a keywords file .sql.dict (optional, but convenient): false null true access add as asc begin by chec... It would be nice to add the tables names also. Create an alias for sqlplus (put it in .bashrc ): alias sqlplus='rlwrap -f $HOME/.sql.dict sqlplus'

These are the steps to install the Oracle sqlplus command line utility on Ubuntu Linux: Get Oracle instant client packages from Oracle (you'll need basic or basiclite + sqlplus). Install the RPM files with alien : $ sudo alien -i oracle-instantclient11.2-basic-11.... Install Oracle shared libraries: create file /etc/ld.so.conf.d/oracle.conf and add this line: /usr/lib/oracle/11.2/client/lib then run sudo ldconfig

This is a utility to generate SQL insert statements for Oracle for one table, or a set of tables. It doesn't cover all possibilities but should be good enough for most cases. import java.io.*; import java.sql.*; import ... To generate insert statements for multiple tables, simply put the table names in a file, one per line, and use the -f switch.

Solution: grant unlimited tablespace to <user> or alter user <user_name> quota 250m on <tablespace_n... Example: SQL> create table customer ( 2 id number(9),...

The ORA-06512 code is not the actual error. It merely indicates on which line the error occurred. The real error precedes ORA-06512 . For example: ERROR at line 1: ORA-29400: data cartridge e...

Use alter package to recompile a PL/SQL package. SQL> alter package UTIL compile; Warning: P...

I get this error using PL/SQL to enqueue a JMS message in Oracle XE: Oracle: PLS-00302: component 'CONSTRUCT' must be declared . Following an advice I found on the web , I ran the script "$ORACLE_HOME/rdbms/admin/prvtaqal.plb" as SYS in sqlplus. That worked even though I got a bunch of errors running the script: Warning: Package created with compilation errors. ...

This tip was mentioned in a previous note . It is repeated here for better searchability. SELECT type, name, line FROM user_source W...

Oracle provides two versions of SQLPlus: a command line version ( sqlplus.exe ) and a windows version ( sqlplusw.exe ). The windows version is rather primitive (ever used Windows 3.1?), but it moved many commands/options to the menus. So it may still be easier to get started with it then the command line version. However, you may be better off with the command line version after you get somewhat familiar with SQLPlus. In SQL*Plus you can enter: SQL*Plus commands. For a list of commands enter help index at the SQL prompt SQL commands - SQL statements sent to the database. These statements are terminated by semicolon unless you change it PL/SQL blocks - Blocks of PL/SQL code. When you enter a SQL command or PL/SQL...

Variable Description SET AUTO [COMMIT] {ON | OFF | IMM [EDIATE] | n} Controls when Oracle Database commits pending changes to the database. SET CMDS [EP] {; | c | ON | OFF} Sets the non-alphanumeric character used to separate multiple SQL*Plus commands entered on one line to c. SET CON [CAT] {. | c | ON | OFF} Sets the character you can use to terminate a substitution variable reference if you wish to immediately follow the variable with a character that SQL*Plus would otherwise interpret as a part of the substitution variable name. SET ECHO {ON | OFF} Controls whether the START (@) command lists each command in a script as the command is executed. SET EDITF [ILE] file_name[.ext] Sets the default filename...