if it is not asked, then it means, the ORACLE_HOME is having the value.
Code:
if [ -z $ORACLE_HOME ] # True if the length of string string is zero
then
echo "Enter the value of ORACLE_HOME"
read ORACLE_HOME
export $ORACLE_HOME
else
echo "ORACLE_HOME has the value of $ORACLE_HOME"
fi
Hi all,
I am having problem with a shell script. I have a couple of csv files. The shell script will do some operation on them, create a sql file which will then be called by sqlplus. The problem is to gracefully exit sqlplus at the end of every operation as I do not want to hang on to the... (4 Replies)
Hi All,
Does anyone have any solutions for passing back multiple variables back to the SHELL from a call to an ORACLE procedure:
eg
#username='scott'
#password='tiger'
#database='orcl'
username='ITGCD03D03'
password='tC5epIew'
database='ITGCD03D'
sqlplus -s... (4 Replies)
Hi all,
passwd <username> < /var/adm/passwd.txt
cat /var/adm/passwd.txt
abcd1234
abcd1234
when I run this from the script, it comes with:
New password:
It is not able to pick from the location /var/adm/passwd.txt.
thanks in advance. (6 Replies)
Hi,
I have several users to create on my test Oracle database taking the scripts from the Production Oracle database. I have a separate text file where I have user-id and passwords maintained. I need help in writing a shell script to go thru the user creation scripts and replace VALUES... (1 Reply)
Hi,
For connecting to oracle my script is using the command
sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command
sqlplus... (4 Replies)
Hi,
Oracle 9.2
Solaris 10
From the shell script ........How can we verify whether oracle connection is successful or not ?
Shell script will prompt the user to enter the oracle schema username, password and tns name.
So, *how to verify whether oracle connection has been established or... (14 Replies)
Hi,
We have Oracle Connection parameters set up in file name "TESTDB" at location /abc/etc.When I try to run my shell script it does not connect to Oracle database. Please let me know how "TESTDB" file can be called inside script.
####################### Setting the directories... (2 Replies)
I have a question regarding how to connect to Oracle Database through shell script.
1. If I want call a stored procedure on Linux server as this, it works.
$sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 12 14:49:49 2015
Copyright (c) 1982, 2014, Oracle. All rights... (2 Replies)
i have a script that connects to the oracle database and executes the query statements. it works fine and i would like to add some message to check if the connection to oracle is not successful.
basically this is the code snippet:
#!/bin/sh
...
...
...
sqlplus -s username/password@dbName... (2 Replies)
Discussion started by: wtolentino
2 Replies
LEARN ABOUT PHP
get_meta_tags
GET_META_TAGS(3) 1 GET_META_TAGS(3)get_meta_tags - Extracts all meta tag content attributes from a file and returns an arraySYNOPSIS
array get_meta_tags (string $filename, [bool $use_include_path = false])
DESCRIPTION
Opens $filename and parses it line by line for <meta> tags in the file. The parsing stops at </head>.
PARAMETERS
o $filename
- The path to the HTML file, as a string. This can be a local file or an URL.
Example #1
What get_meta_tags(3) parses
<meta name="author" content="name">
<meta name="keywords" content="php documentation">
<meta name="DESCRIPTION" content="a php manual">
<meta name="geo.position" content="49.33;-86.59">
</head> <!-- parsing stops here -->
(pay attention to line endings - PHP uses a native function to parse the input, so a Mac file won't work on Unix).
o $use_include_path
- Setting $use_include_path to TRUE will result in PHP trying to open the file along the standard include path as per the
include_path directive. This is used for local files, not URLs.
RETURN VALUES
Returns an array with all the parsed meta tags.
The value of the name property becomes the key, the value of the content property becomes the value of the returned array, so you can eas-
ily use standard array functions to traverse it or access single values. Special characters in the value of the name property are substi-
tuted with '_', the rest is converted to lower case. If two meta tags have the same name, only the last one is returned.
EXAMPLES
Example #2
What get_meta_tags(3) returns
<?php
// Assuming the above tags are at www.example.com
$tags = get_meta_tags('http://www.example.com/');
// Notice how the keys are all lowercase now, and
// how . was replaced by _ in the key.
echo $tags['author']; // name
echo $tags['keywords']; // php documentation
echo $tags['description']; // a php manual
echo $tags['geo_position']; // 49.33;-86.59
?>
NOTES
Note
Only meta tags with name attributes will be parsed. Quotes are not required.
SEE ALSO htmlentities(3), urlencode(3).
PHP Documentation Group GET_META_TAGS(3)