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 DEBIAN
swf::textfield
.::SWF::TextField(3pm) User Contributed Perl Documentation .::SWF::TextField(3pm)NAME
SWF::TextField - SWF TextField class
SYNOPSIS
use SWF::TextField;
$textfield = new SWF::TextField([$flags]);
DESCRIPTION
Unlike SWF::Text objects, TextFields cannot be rotated, scaled non-proportionally, or skewed. However, TextFields can be used as form
entries and they can use browser-defined fonts.
NOTES :
TextField is implemented into Flash since Flash3.
Most of features for TextFields are available since Flash4.
Simple HTML-tags in TextField are possible since Flash5.
METHODS
new SWF::TextField([$flags]);
Creates a TextField object whose behaviour is dictated by "flags" (see also SWF::Constants):
SWFTEXTFIELD_NOEDIT: Non-editable Textfiled
SWFTEXTFIELD_PASSWORD: Obscure user input with astricts.
SWFTEXTFIELD_DRAWBOX: Draw a border around TextField
SWFTEXTFIELD_MULTILINE: TextFiels may contain multiple lines
SWFTEXTFIELD_WORDWRAP: Warp text when text reaches TextField border
SWFTEXTFIELD_NOSELECT: TextField is not selected when user clicks on it
SWFTEXTFIELD_ALIGN_LEFT: Align text to the left
SWFTEXTFIELD_ALIGN_RIGHT: Align text to the right
SWFTEXTFIELD_ALIGN_CENTER: Align text to the center
SWFTEXTFIELD_ALIGN_JUSTIFY: Justify text
SWFTEXTFIELD_HTML: Add HTML markup string
SWFTEXTFIELD_HASLENGTH:
SWFTEXTFIELD_USEFONT: Want to embed font
SWFTEXTFIELD_AUTOSIZE:
Flags may be combined with the bitwise OR operation. For example:
my $t = new SWF::TextField(SWFTEXTFIELD_MULTILINE | SWFTEXTFIELD_WORDWRAP);
$textfield->addString($string)
$textfield->addUTF8String($UTF8string)
Add $string to TextField. Text is appended to the existing text.
$textfield->align($alignment)
$textfield->setAlignment($alignment)
Set the alignment of the text in the textfield. Possible values are
SWFTEXTFIELD_ALIGN_LEFT
SWFTEXTFIELD_ALIGN_RIGHT
SWFTEXTFIELD_ALIGN_CENTER
SWFTEXTFIELD_ALIGN_JUSTIFY
By default a SWF::TextField ist left aligned.
$textfield->setBounds($width, $height)
Sets the width and height of the textfield.
$textfield->setColor($red, $green, $blue [, $alpha])
Set the color of the text. An 8 bit value for each parameter. You can use the hex or decimal notation. Even mixed.
$tf->setColor(0xcc,0,0x33);
$tf->setColor(204,0,51,255);
$textfield->setFont($font)
Sets an SWF::Font object -$font- to be used in the TextField.
$textfield->setPadding($padding)
Set TextField padding.
$textfield->setHeight($height)
Set the height of font in your textfield.
$textfield->setIndentation($indentation)
Set the indentation of the first line of a paragraph.
$textfield->setLeftMargin($left)
Sets the left margin of the textfield.
$textfield->setRightMargin($right)
Sets the right margin of the textfield.
$textfield->setMargins($left, $right)
Sets left and right margins of $textfield.
$textfield->setLineSpacing($linespacing)
Sets the space between lines.
$textfield->setName($name)
$textfield->setVariableName($name)
Assigns a name to the TextField which could be used to reference the TextField within ActionScript.
$textfield->addChars($string)
$textfield->addUTF8Chars($UTF8string)
Adds characters to a font that will be available within a textfield.
$textfield->setFlags($flags)
Set TextField behaviour by "flags" (see above new SWF::TextField) For example:
$textfield->setFlags(SWFTEXTFIELD_PASSWORD);
$textfield->setLength($length)
Sets limit for user input size to $length.
$textfield->setFieldHeight($height)
Sets height limit for visible part of text field. If $height is set to 0, the height is calculated by used font, see setHeight()
method.
AUTHOR
Soheil Seyfaie (soheil at users.sourceforge.net).
SEE ALSO
SWF, SWF::Action, SWF::Button, SWF::Constants, SWF::DisplayItem, SWF::Font, SWF::Movie, SWF::MovieCip, SWF::Text
perl v5.14.2 2011-10-26 .::SWF::TextField(3pm)