Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Script:
Conditional update
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
If between control
Shell scripting...
Script:
Script for archiving and compressing folder and file
Un servizio Web XML è un'unità logica di applicazioni che fornisce dati e servizi ad altre applicazioni.
Le applicazioni accedono ai servizi Web XML tramite protocolli Web universali e formati di dati quali HTTP, XML e SOAP.
Php Funzione mail()
La J2EE (Java 2 Enterprise Edition) è dedicata a tutti coloro che desiderano aggiungere il supporto della versione Enterprise di Java (ad esempio a Tomcat) e quindi le funzionalità avanzate come Enterprise JavaBeans etc.
Un servizio Web XML è un'unità logica di applicazioni che fornisce dati e servizi ad altre applicazioni.
Le applicazioni accedono ai servizi Web XML tramite protocolli Web universali e formati di dati quali HTTP, XML e SOAP.
|
Shell scripting
Home >Shell scripting > Function connecting to oracle
The following is a base example of a shell script function that I use to connect to Oracle and execute sql statements. Certainly there are various option to connect and get db results within a shell script, but I tend to adopt this combination of print [ sql code] | sqlplus -s [...] because it works fine on different Oracle db versions (8i, 10g). This sample function checks if the schema owns/reads the object passed, if the object is not in all_objects you get the no rows selected. The some construct can be used to get results, execute a procedure, drop an object, etc. As showed in the second part, the function may be a good trick to verify database connection, in fact if the function does not return the table DUAL (or another table) accessible from a schema, it means there was not logon into the db. #!/usr/bin/ksh # file fun_chkobj #tested on HP-UX B.11.23 U ia64 fun_chkobj() { vdbschema=$1 vpass=$2 database=$3 obj=$4 voutput=`print "set heading off \n select table_name from all_tables where table_name ='$obj' ;"| sqlplus -s ${vdbschema}/$vpass@${database}` echo $voutput } # calling the function v=$(fun_chkobj "SALES" "PSWSALES" "CUSTOMER" "MYTABLE"); # printing function result echo $v # executing the function using echo, this time there is not object echo `fun_chkobj "ABPESDBO" "ABPESDBO123" "ACCAR2C1" "ANOTEXISTENTOBJECT"` # implementing the function to verify connection parameters chkConn=$(fun_chkobj "SYSTEM" "MANAGER" "DBCUSTOMER" "DUAL"); if [ "${chkConn}" != "DUAL" ] then echo " Cannot connect to db" exit fi Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
CercaWell-formedness is a new concept introduced by [XML]. Essentially this means that all elements must either have closing tags or be written in a special form (as described below), and that all the elements must nest properly.
Well-formedness is a new concept introduced by [XML]. Essentially this means that all elements must either have closing tags or be written in a special form (as described below), and that all the elements must nest properly.
Oracle...
Definizioni:
SESSION
Shell scripting...
Script:
Array
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |