10-11-2012
SQL db check
Ive debated this for awhile after I ran into a crap load of issues with my hosting's SQL server. I was curious to know if there is a way to write a db check into my .htaccess file that would verify if a connection is present and if not transfer to another domain?? I know it can be done manually in Cpanel (domain fowarding) but I would like a way for this to be into play instead of SQL errors. Ideas??
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: rajagavini
5 Replies
2. UNIX for Dummies Questions & Answers
Hi Guys,
I wanted to check the sql connection through scripting if it is avilable then proceed else stop the process
I was trying
sqlplus -L username/passwd@sid
if this is not sucess it gives non-zero.
but if it is success it is going into the sqlplus prompt.
So how could i get out... (2 Replies)
Discussion started by: Swapna173
2 Replies
3. Shell Programming and Scripting
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Discussion started by: djehres
2 Replies
4. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: reptile
1 Replies
5. Shell Programming and Scripting
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;... (6 Replies)
Discussion started by: guif
6 Replies
6. UNIX for Advanced & Expert Users
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... (3 Replies)
Discussion started by: huasheng8
3 Replies
7. Shell Programming and Scripting
Hello,
I have two .sql files which I transferred from Windows to Unix (Linux Enterprise Linux Server release 5.3).I want to ensure that these two files have no junk characters in them.How do I do it in the simplest possible way?
Many thanks
DJ (1 Reply)
Discussion started by: Digjoy83
1 Replies
8. Shell Programming and Scripting
I use below command to log in to oracle database
sqlplus username/passwordWhen i enter into sql prompt i press quitIf there are any errors it will show just below the output of sqlplus username/password. The errors generally start with keyword ORA can we do this by using a unix shell script.?... (4 Replies)
Discussion started by: Nakul_sh
4 Replies
9. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 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)