Oracle 11g: Another New SQL*Plus Command
Posted by Grégory Guillou on Jan 25, 2008
I have been using this SQL*Plus command for a while now:
SQL> show spparameter service_names
SID NAME TYPE VALUE
-------- ------------- ----------- ---------
* service_names string REDX
And guess what ?
- The right syntax is actually
show spparameters(with a “s” at the end of it). - It’s an 11g New Feature!
It doesn’t work with 10g:
SQL> show spparameters service_names SP2-0735: unknown SHOW option beginning "spparamete..." SP2-0735: unknown SHOW option beginning "service_na..."
I thought MySQL was trying to become as big as Oracle but it could be that Oracle is trying to become as cool as MySQL — it has had something like this for a long time! Now Oracle should add SHOW TABLES too.
Anyway, this is really 11g’s most useful feature so far, though.
Category: Oracle
Tags: new features, Oracle 11g, sqlplus
