TO execute .sql 2005 query file in shell script

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv...

2. Shell Programming and Scripting

Shell script to execute sql query.

Hi Experts, Need your support. Not able to use sql query alias in shell script. Could you please help me in finding right way to use alias with sql query in shell script. Below is the code i am using. #!/bin/bash sqlplus -s abc/abc@abc << EOF> bcd.csv set trimspool on select zone_id...

3. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup...

4. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

5. Shell Programming and Scripting

Execute SQL query in unix script

Hi I am new in unix. oracle and unix are installed in my sytem.i need the script which could connect to the oracle using username ,password and schema and can run the select * from tab query. Thanks vijay

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

7. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance!

8. 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...

9. Shell Programming and Scripting

Shell Script to execute SQL's

Hi people, i need youre help on this. I need to create an Shell SCript to list in a directory some sql files and then execute them one by one . Also i need to have Logs from the executed Sql's to send to our costummers. Can anyone help me on this Regards, osramos

10. Shell Programming and Scripting

How to execute a .sql file with shell script

hi everybody... can anyone help me in executing the .sql file with shell scripting.... thanx in advance

LEARN ABOUT PHP

fbsql_read_blob

FBSQL_READ_BLOB(3)							 1							FBSQL_READ_BLOB(3)

fbsql_read_blob - Read a BLOB from the database

SYNOPSIS

       string fbsql_read_blob (string  $blob_handle, [resource	$link_identifier])

DESCRIPTION

	Reads BLOB data from the database.

	If  a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behav-
       ior can be changed with fbsql_set_lob_mode(3) so the fetch functions will return handles to BLOB and CLOB data. If a handle  is	fetched  a
       user must call fbsql_read_blob(3) to get the actual BLOB data from the database.

PARAMETERS

	      o $blob_handle
		- A BLOB handle, returned by fbsql_create_blob(3).

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns a string containing the specified BLOB data.

EXAMPLES

       Example #1

	      fbsql_read_blob(3) example

	      <?php
	      $link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
		  or die("Could not connect");
	      $sql = "SELECT BLOB_COLUMN FROM BLOB_TABLE;";
	      $rs = fbsql_query($sql, $link);
	      $row_data = fbsql_fetch_row($rs);
	      // $row_data[0] will now contain the blob data for the first row
	      fbsql_free_result($rs);

	      $rs = fbsql_query($sql, $link);
	      fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
	      $row_data = fbsql_fetch_row($rs);
	      // $row_data[0] will now contain a handle to the BLOB data in the first row
	      $blob_data = fbsql_read_blob($row_data[0]);
	      fbsql_free_result($rs);

	      ?>

SEE ALSO

       fbsql_create_blob(3), fbsql_read_clob(3), fbsql_set_lob_mode(3).

PHP Documentation Group 													FBSQL_READ_BLOB(3)

Shell Programming and Scripting