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
strip_tags
STRIP_TAGS(3) 1 STRIP_TAGS(3)strip_tags - Strip HTML and PHP tags from a stringSYNOPSIS
string strip_tags (string $str, [string $allowable_tags])
DESCRIPTION
This function tries to return a string with all NULL bytes, HTML and PHP tags stripped from a given $str. It uses the same tag stripping
state machine as the fgetss(3) function.
PARAMETERS
o $str
- The input string.
o $allowable_tags
- You can use the optional second parameter to specify tags which should not be stripped.
Note
HTML comments and PHP tags are also stripped. This is hardcoded and can not be changed with $allowable_tags.
Note
This parameter should not contain whitespace. strip_tags(3) sees a tag as a case-insensitive string between < and the first
whitespace or >.
Note
In PHP 5.3.4 and later, you will also need to include the self-closing XHTML tag to strip these from $str. For example, to
strip both <br> and <br/>, you should use:
<?php
strip_tags($input, '<br><br/>');
?>
RETURN VALUES
Returns the stripped string.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.4 | |
| | |
| | strip_tags(3) no longer strips self-closing XHTML |
| | tags unless the self-closing XHTML tag is also |
| | given in $allowable_tags. |
| | |
| 5.0.0 | |
| | |
| | strip_tags(3) is now binary safe. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
strip_tags(3) example
<?php
$text = '<p>Test paragraph.</p><!-- Comment --> <a href="#fragment">Other text</a>';
echo strip_tags($text);
echo "
";
// Allow <p> and <a>
echo strip_tags($text, '<p><a>');
?>
The above example will output:
Test paragraph. Other text
<p>Test paragraph.</p> <a href="#fragment">Other text</a>
NOTES
Warning
Because strip_tags(3) does not actually validate the HTML, partial or broken tags can result in the removal of more text/data than
expected.
Warning
This function does not modify any attributes on the tags that you allow using $allowable_tags, including the style and onmouseover
attributes that a mischievous user may abuse when posting text that will be shown to other users.
Note
Tag names within the input HTML that are greater than 1023 bytes in length will be treated as though they are invalid, regardless
of the $allowable_tags parameter.
SEE ALSO htmlspecialchars(3).
PHP Documentation Group STRIP_TAGS(3)