Using DOS to play Oracle code tricks

Beginners to learn Oracle will generally use Sqp*plus to play the Oracle code, but ORACLE10 is not to copy the paste operation, so need to use DOS to operate, more simple, of course, Sql*plus also has its own advantages

To use DOS, first configure the environment variables, win7 system is my computer, advanced system settings, advanced environment variables, and then in the system variable, find path, no, add it yourself

, you need to add%oracle_home%/bin

After configuration, the direct window key +r, jump out of the run, input cmd, enter, input Sqlplus/nolog

Direct access

Then the other database operations and the use of spl*plus, just can paste copy



Using DOS to play Oracle code tricks