Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
Hi,
even after i am setting the trace on(set -x), trace is not printed.
can you please tell me what is the error. below is the code & output.
Thanks in advance,
Harish
-------------------------------------------------
test.sh
-------------------------------------------------
#!... (5 Replies)
Hi All,
I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time.
These 25 process creates 25 different files.
When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25... (1 Reply)
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Hi
Got 2 solaris boxes - one uses set -o vi happily (put it in .profile)
The other reports: -o: bad option(s)
Both are solaris 9 and both users have $SHELL set to /bin/ksh
Any ideas??
Thanks (4 Replies)
Hi All,
I am facing a strange problem on one of my unix servers.
When i try to login using the standard method:
it fails with below message
>sqlplus REF1SSTDBO1/REF1SSTDBO1@TKS3N10G
> TKS3N10G
ksh: TKS3N10G: not found
But it works perfectly when i escape with ;\
>sqlplus... (3 Replies)
Hi All,
I am using the following script to run some sql on database but i am not getting the result. When i tried the same by removing "-s" option it is working fine but getting other things as well with my input as shown below. Can anyone please suggest why "-s" option is not working in AIX and... (2 Replies)
I have below SQL that I wasnt to run from a solaris machine using sqlplus
select * from TABLE_NAME where regexp_like(field_value, 'Α|Β|Γ|Δ|Ε|Ζ|Η|Θ|Ι|Κ|Λ|Μ|Ν|Ξ|Ο|Π|Ρ|Σ|Τ|Υ|Φ|Χ|Ψ|Ω|α|β|γ|δ|ε|ζ|η|θ|ι|κ|λ|μ|ν|ξ|ο|π|ρ|σ|τ|υ|φ|χ|ψ|ω');
When I cat the file UTF char shows perfect however when i run... (1 Reply)
Hi Gurus,
I was trying to execute sqlplus command remotely like
ssh -q IP venkat@"which sqlplus"
am getting error as which: no sqlplus in (/usr/local/bin:/bin:/usr/bin)
if i connect manually and executing which sqlplus it working fine.
Please help to fix the issue.
Regard's
Venky (7 Replies)
"SQLPLUS -S " is not working in one environment where same code is working in another
getting below error
===================================
SQL*Plus: Release 11.2.0.3.0 Production
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus... (1 Reply)
Discussion started by: yogendra.barode
1 Replies
LEARN ABOUT PHP
datefmt_localtime
DATEFMT_LOCALTIME(3) 1 DATEFMT_LOCALTIME(3)IntlDateFormatter::localtime - Parse string to a field-based time value
Object oriented style
SYNOPSIS
public array IntlDateFormatter::localtime (string $value, [int &$position])
DESCRIPTION
Procedural style
array datefmt_localtime (IntlDateFormatter $fmt, string $value, [int &$position])
Converts string $value to a field-based time value ( an array of various fields), starting at $parse_pos and consuming as much of the
input value as possible.
PARAMETERS
o $fmt
- The formatter resource
o $value
- string to convert to a time
o $position
- Position at which to start the parsing in $value (zero-based). If no error occurs before $value is consumed, $parse_pos will
contain -1 otherwise it will contain the position at which parsing ended . If $parse_pos > strlen($value), the parse fails immedi-
ately.
RETURN VALUES
Localtime compatible array of integers : contains 24 hour clock value in tm_hour field
EXAMPLES
Example #1
datefmt_localtime(3) example
<?php
$fmt = datefmt_create(
'en_US',
IntlDateFormatter::FULL,
IntlDateFormatter::FULL,
'America/Los_Angeles',
IntlDateFormatter::GREGORIAN
);
$arr = datefmt_localtime($fmt, 'Wednesday, December 31, 1969 4:00:00 PM PT', 0);
echo 'First parsed output is ';
if ($arr) {
foreach ($arr as $key => $value) {
echo "$key : $value , ";
}
}
?>
Example #2
OO example
<?php
$fmt = new IntlDateFormatter(
'en_US',
IntlDateFormatter::FULL,
IntlDateFormatter::FULL,
'America/Los_Angeles',
IntlDateFormatter::GREGORIAN
);
$arr = $fmt->localtime('Wednesday, December 31, 1969 4:00:00 PM PT', 0);
echo 'First parsed output is ';
if ($arr) {
foreach ($arr as $key => $value) {
echo "$key : $value , ";
}
}
?>
The above example will output:
First parsed output is tm_sec : 0 , tm_min : 0 , tm_hour : 16 , tm_year : 1969 ,
tm_mday : 31 , tm_wday : 4 , tm_yday : 365 , tm_mon : 11 , tm_isdst : 0 ,
SEE ALSO datefmt_create(3), datefmt_format(3), datefmt_parse(3), datefmt_get_error_code(3), datefmt_get_error_message(3).
PHP Documentation Group DATEFMT_LOCALTIME(3)