07-05-2011
I need to pipe the SQL Spool to another loading program....Thats why..
10 More Discussions You Might Find Interesting
1. Windows & DOS: Issues & Discussions
This question maybe in the wrong category but I'm posting here due to urgency.
In DOS is there a command to perform a similar function to spool command in SQL or Script command in UNIX?
I want to print all command line output to a file but I don't want to use the echo command for each line.
... (2 Replies)
Discussion started by: stevefox
2 Replies
2. Shell Programming and Scripting
Hi,
I am getting the error "No matching <<", when i run the below. Is it that we can't execute SQL in a Unix loop. I am executing a SQL in a loop. Is it the EOF is written wrongly.
. /opt/app/wlsconfigv61/domains/profiles/oracleV901.profile
export DBUSER=ecdb01
set -A DBINSTANCE... (3 Replies)
Discussion started by: manu_byc
3 Replies
3. Shell Programming and Scripting
I am currently trying to find a way to loop through files in a given directory and for each file modify a ctl file and sql load it. I have been using the sed command to change the infile, badfile parameters of the control file. I have not yet tried to sql load it.
Requirement: files are ftp to... (1 Reply)
Discussion started by: dba_nh
1 Replies
4. Programming
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies
5. Shell Programming and Scripting
Trying to compile all SQL files using a shell script. But the below code is not working. Below Code works fine when for loop is not there(commenting line no: 1,2 and 9).
1. sq_lfile=`ls *.sql`
2. for current_sql_file in $sql_file
3. do
4. sqlplus uname/pass@Service>>SQLLOG << -ENDOFSQL... (3 Replies)
Discussion started by: Dip
3 Replies
6. Shell Programming and Scripting
Hi all,
I am executing shell script in which I am using SQLLDR
In this SQLLDR I am passing text file having PL/SQL script. This script will produce some formated output, this output I have to spool in another text file. Currently I have given this in script file as following
Spool... (2 Replies)
Discussion started by: shekharjchandra
2 Replies
7. Shell Programming and Scripting
Hi,
Im writing a script to run a bit of sql(via sqlplus) that pulls back some data and spools it to a file, I want the spool file to only display the data, with no sql command at the top and no reports at the bottom ie(# of records recieved).
I am currently doing it via a grep command but... (1 Reply)
Discussion started by: Magezy
1 Replies
8. Programming
this is my issue.
4 parameters are passed from korn shell to sql script.
parameter_1= varchar2 datatype or no value entered my user.
parameter_2= number datatype or no value entered my user.
parameter_3= number datatype or no value entered my user.
parameter_4= number datatype or no... (5 Replies)
Discussion started by: megha2525
5 Replies
9. Shell Programming and Scripting
SQL*Plus version : 11.2.0.4
OS : Oracle Linux 6.5
SQL*Plus is a client application to connect to oracle database. The log file for this tool is generated via spool command as shown below.
I am trying to append date ( $dateString ) to spool file as shown below.
$ cat test2.sh
#!/bin/bash... (4 Replies)
Discussion started by: kraljic
4 Replies
10. UNIX for Beginners Questions & Answers
Hello ,
Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this..
How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies
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)