Sponsored Content
Top Forums Shell Programming and Scripting Connecting to Oracle Database Post 57976 by dreams5617 on Thursday 11th of November 2004 09:55:42 AM
Old 11-11-2004
Connecting to Oracle Database

if[ $action = 'export' ];
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`

I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?

Appreciate your reply in this regard......

Thanks
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem in Connecting to Oracle Database using KornShell

Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it. #!/bin/ksh ssh -X root@192.168.2.127 <perimuka> sleep 5 su - oracle sqlplus <mraghunandanan>/<peri123> <<eof Can anyone tell what is wrong... (3 Replies)
Discussion started by: mraghunandanan
3 Replies

2. Shell Programming and Scripting

Connecting to oracle database from shell script

Hi all, I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know 1. how to connect to the data base(oracle) using shell script 2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies

3. Shell Programming and Scripting

Connecting to Database

Hi, I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not? Can anyone help me in this regard? Appreciate your help and concern. Thanks, Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies

4. Shell Programming and Scripting

Connecting to oracle database

Hai i want to connect to oracle database from user input and create a view. ${ECHO} "Debut Creating View" ${ECHO} "Please Enter the User Name:" read user_name ${ECHO} "Please Enter the Connection String:" read con_string ${ECHO} "Please Enter the Password:" read pwd... (3 Replies)
Discussion started by: shenthil76
3 Replies

5. Solaris

Connecting to Oracle database

Hi guys, long time no typing :D I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box. Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
DBX_ESCAPE_STRING(3)							 1						      DBX_ESCAPE_STRING(3)

dbx_escape_string - Escape a string so it can safely be used in an sql-statement

SYNOPSIS
string dbx_escape_string (object $link_identifier, string $text) DESCRIPTION
Escape the given string so that it can safely be used in an sql-statement. PARAMETERS
o $link_identifier - The DBX link object returned by dbx_connect(3) o $text - The string to escape. RETURN VALUES
Returns the text, escaped where necessary (such as quotes, backslashes etc). On error, NULL is returned. EXAMPLES
Example #1 dbx_escape_string(3) example <?php $link = dbx_connect(DBX_MYSQL, "localhost", "db", "username", "password") or die("Could not connect"); $text = dbx_escape_string($link, "It's quoted and backslashed (\)."); $result = dbx_query($link, "insert into tbl (txt) values ('" . $text . "')"); if ($result == 0) { echo dbx_error($link); } dbx_close($link); ?> SEE ALSO
dbx_query(3). PHP Documentation Group DBX_ESCAPE_STRING(3)
All times are GMT -4. The time now is 04:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy