| Looking for a Oracle feature that will fail when client is lower version than database [message #658269] |
Wed, 07 December 2016 14:07  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
I seem to recall years ago, maybe MANY years ago when the SQL engine and PL/SQL engine were not in sync, that if I was using a SQL*Plus client at a lower version that the database, if that feature (eg. built-in function for example) wasn't available in the version that the client was, it would not work.
I tested using the row limiting of Top-N queries of 12c using a 10g client and it worked. I was expecting it to fail.
select *
from user_objects
order by OBJECT_NAME
fetch first 5 rows only;
Is it possible it was only DDL and not DML?
|
|
|
|
| Re: Looking for a Oracle feature that will fail when client is lower version than database [message #658271 is a reply to message #658269] |
Wed, 07 December 2016 14:45  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It is possible to use any statement if SQL*Plus recognizes the first keyword which is the only thing it checks.
For instance, with a 10g SQL*Plus you can create an edition on a 11g database:
C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Mer. DÚc. 7 21:41:55 2016
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn michel/michel@mikb2
Connected.
SQL> def _SQLPLUS_RELEASE
DEFINE _SQLPLUS_RELEASE = "1002000400" (CHAR)
SQL> @v
Oracle version: 11.2.0.4.0
SQL> create edition foo;
Operation 212 succeeded.
SQL> select * from dba_editions;
EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES
TOTO ORA$BASE YES
FOO TOTO YES
3 rows selected.
SQL> drop edition foo;
Operation 214 succeeded.
SQL> select * from dba_editions;
EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES
TOTO ORA$BASE YES
2 rows selected.
[Updated on: Wed, 07 December 2016 15:44] Report message to a moderator |
|
|
|
|
|
| Re: Looking for a Oracle feature that will fail when client is lower version than database [message #658277 is a reply to message #658269] |
Thu, 08 December 2016 02:21 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Got one! Following MC's comment, I thought of a new 12.x command. First, SQL*Plus 11 and DB 12:
C:\Users\john>
C:\Users\john>sqlplus sys/oracle@127.0.0.1:1521/orclz as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 8 08:18:01 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
127.0.0.1:1521/orclz> administer key management;
SP2-0734: unknown command beginning "administer..." - rest of line ignored.
127.0.0.1:1521/orclz>
C:\Users\john>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 8 08:14:44 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
orclz> administer key management;
administer key management
*
ERROR at line 1:
ORA-46600: invalid ADMINISTER KEY MANAGEMENT command
orclz> |
|
|
|
|
|
|
|
|
|
| Re: Looking for a Oracle feature that will fail when client is lower version than database [message #658308 is a reply to message #658282] |
Thu, 08 December 2016 08:57 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Great info guys. John, good one, but the administer key management is more of a "system" command. I could have wore there was something more "generic" that I recall a user trying to run that didn't work.
The reason I ask is that we have 12c databases and most developers use SQL Developer, but I don't like GUI, so I use a linux box to connect the database and it has a 10g client. I don't want to come across a situation where I cannot create something that won't work because of the limitation of the client.
Cookie, I don't recall when WITH was first introduced. I have instant client all the way back to 9i and I even have an 8.0.6 Windows client that came with Forms 6i that I can try out.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
