SHELL KBASH with Oracle Edition-Based Redefinition

Shell Programming and Scripting
1

hi everyone, i'm learning on Oracle 11g and my team have asked me for edition-based redifinition, have you the script? or another idea?

Thanks

2

Seems that there's plenty of information available about this (i.e. like here) if you're willing to Google it.

Did you have a specific question about it, or something you don't understand?

3

thanks for reply, i've visited this link and i'll want to know that i can to have the possibility for use script with this edition based? i've tried with this script like sample:

#!/bin/bash
UTENTE="$1"
PASSW="$2"
RETVAL='sqlplus "$UTENTE"/"$PASSW"<<EOF
BEGIN
  DBMS_SERVICE.modify_service(
    service_name   => 'oc11g.local',
    edition        => null,
    modify_edition => TRUE);
END;
/
EXIT;
EOF'

$RETVAL

but work only to connect, not on change edition....