Communitcating between UNIX and SQL Scripts

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX Solution - Calling SQL*Plus scripts

I have a requirement of bash shell script calling SQL*Plus script. Shell Script sqlplus <user>/<pwd> @sqlscript1 parameters sqlplus <user>/<pwd> @sqlscript2 parameters Now I need the values generated by sqlscript1 in sqlscript2. But it is more like a huge dataset in a table and not one...

2. Shell Programming and Scripting

Issue in SQL Loader scripts

3. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

4. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

6. Shell Programming and Scripting

any possible solution on sql calling scripts

hi all, i have a function which will take i/p as a ddl sctipt as i/p and execute it, let function execute_sql { db_var="$1" v_cnt=`sqlplus -s XXXXX/XXXXX@aXXX << ENDSQL | sed -e "s/Connected\.//" -e "/^$/d" set pagesize 0 feedback off verify off heading off echo off serveroutput on size...

7. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

8. UNIX for Dummies Questions & Answers

SQL and shell scripts

Initial code is modified...Can u help me with the next post.....

9. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Oracle and Scripting gurus, I need some help with this script... I am trying to add the query SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'METADATA' in the current script.... Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg....

10. Shell Programming and Scripting

Help with GDL to SQL scripts

Hi to everyone, i want ask if someone knows about a script/program to convert the .gdl (Interbase) to .sql scripts. I wrote a little script to make it but it's very very simple, and the triggers and some code from .gdl are so difficult to me. If somebody could help me, I would very thankful. ...

LEARN ABOUT PHP

sql-types-with-pdo_4d-and-php

SQL-TYPES-WITH-PDO_4D-AND-PHP(3)					 1					  SQL-TYPES-WITH-PDO_4D-AND-PHP(3)

SQL types with PDO_4D and PHP - SQL types with PDO_4D and PHP

       Supported SQL types

       +-----------------+--------------------------------------+---+
       |  Type SQL 4D	 |					|   |
       |		 |					|   |
       |		 |	      Equivalent 4D		|   |
       |		 |					|   |
       |		 |		   Note 		|   |
       |		 |					|   |
       +-----------------+--------------------------------------+---+
       | ALPHA_NUMERIC	 |					|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ VARCHAR		|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ TEXT		|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ TIMESTAMP		|   |
       |		 |					|   |
       |		 |		   DATE 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ INTERVAL		|   |
       |		 |					|   |
       |		 |		   HOUR 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ DURATION		|   |
       |		 |					|   |
       |		 |		   HOUR 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ BOOLEAN		|   |
       |		 |					|   |
       |		 |		 BOOLEAN		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		  T{ BIT		|   |
       |		 |					|   |
       |		 |		 BOOLEAN		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ BYTE		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT16		|   |
       |		 |					|   |
       |		 |		 SMALLINT		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ SMALLINT		|   |
       |		 |					|   |
       |		 |		 SMALLINT		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT32		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		  T{ INT		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT64		|   |
       |		 |					|   |
       |		 |		  INT64 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ NUMERIC		|   |
       |		 |					|   |
       |		 |		  INT64 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ REAL		|   |
       |		 |					|   |
       |		 |		   REAL 		|   |
       |		 |					|   |
       |		 | Unsupported (use VARCHAR conversion) |   |
       |		 |					|   |
       |     FLOAT	 |					|   |
       |		 |					|   |
       |		 |		  FLOAT 		|   |
       |		 |					|   |
       |		 | Unsupported (use VARCHAR conversion) |   |
       |		 |					|   |
       |DOUBLE PRECISION |					|   |
       |		 |					|   |
       |		 |		  FLOAT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ BLOB		|   |
       |		 |					|   |
       |		 |		   BLOB 		|   |
       |		 |					|   |
       |		 | Must  use  a prepared statement, and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       |  BIT VARYING	 |					|   |
       |		 |					|   |
       |		 |		   BLOB 		|   |
       |		 |					|   |
       |		 | Must use a prepared	statement,  and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       |      CLOB	 |					|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ PICTURE		|   |
       |		 |					|   |
       |		 |		 PICTURE		|   |
       |		 |					|   |
       |		 | Must  use  a prepared statement, and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       +-----------------+--------------------------------------+---+
PHP Documentation Group 											  SQL-TYPES-WITH-PDO_4D-AND-PHP(3)

UNIX for Dummies Questions & Answers