SQLPlus Enhancements


Page 202

Jonathan Says...

Streams clearly looks like a strategic direction for Oracle. Some of the enhancements in this release (particularly, I think, the changes regarding supplemental logging) promise to make the logical standby database a viable option in the near future.

image A new procedure, dbms_repcat.streams_migration, is available to assist in migrating from Advanced Replication to Streams.

image A new package called dbms_streams_messaging is available to ease the process of enqueueing and dequeueing messages from a sys.AnyData queue.

SQL*Plus Enhancements

Prior to its release, there were some rumors floating around about Oracle Database 10g. One of these was that the SQL*Plus client would be done away with. I'm happy to report that the rumors of the demise of SQL*Plus were premature and that it is very much alive and well. In fact, some enhancements are present in SQL*Plus in Oracle Database 10g:

image Enhancements to the describe command

image Enhancements to the spool command

image Changes to behavior of the SQL*Plus profile files

image New define variables

image The ability to do variable substitution at the SQL prompt

image The new SQL*Plus compatibility command

image Support for whitespace in filenames and paths

Enhancements to the describe Command

If you use rules in the database, you will want to know that the SQL*Plus describe command is now enhanced to describe rules, rule sets, and rule evaluation contexts. Thus, you can quickly look up rule specifications, rather than having to reference the data dictionary views themselves.


Oracle Database 10g New Features
Oracle Database 10g New Features (Osborne ORACLE Press Series)
ISBN: 0072229470
EAN: 2147483647
Year: 2006
Pages: 80

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net