SSH : Port forwarding

ssh username@hostname -L local_ip:local_port:dist_IP:dist_port

Sqlplus on Service Name

sqlplus username/Password@Hostname:Port/Service_Name

JQUERY : Validate + Submit Ajax

Voici le bout de code qui permet d'implémenter la validation de formulaire via le plugin validate de JQuery et de poster la requête Ajax une fois le formulaire validé:

<script type="text/javascript">
  $(document).ready(function(){
        $("#msg").hide();
        $("#MyForm").validate({
                submitHandler : function(){
                        $.ajax({
                                type            : "POST",
                                url             : "test.php",
                                data            : $("#MyForm").serialize(),
                                success         : function(data){
                                        $("#msg").fadeIn(1000);
                                        $("#msg").html(data);
                                }
                        });
                        return false;
                }
        });
  });
</script>

Avec comme Formulaire #MyForm, test.php la page de reply Ajax ...
Enjoy

JDBC : Service Name vs SID

Connexion via SID

jdbc:oracle:thin:scott/tiger@localhost:1521:orcl

Connexion via Service Name

jdbc:oracle:thin:scott/tiger@//localhost:1521:orcl

SQL - Jointures

http://sqlpro.developpez.com/cours/sqlaz/jointures/#LII-B

Wiki - CFT

http://wiki.tuxunix.com/index.php?title=Doc_CFT

sqlldr : ORA-01031: insufficient privileges

SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table "oraman"."TEST_SREE"
ORA-01031: insufficient privileges

==> Ajouter le privilège suivant : "grant drop any table"