Connected to oracle database
sqlplus << EOF
$CONNECTSTR
set heading off
set trimspool on
set feedback off
select ID,DATE from sysadm.TEST where VALUE = 'A' order by ID;
value_id = ID
value_date = DATE
EOF
1. Is it possible to reference the values, ID,DATE in unix shell script.
2.... (20 Replies)
hi all
i have written this small code.
sqlplus $schema_name/$passwrd@$instance <<eof
set serveroutput on;
declare
lv_count pls_integer;
lv_option varchar2(20);
begin
select count(*) into lv_count from all_objects where upper(object_name)=upper('$temp_file1');... (1 Reply)
Hi,
I am passing an argument for the script and that argument values should exist in database.
bill_period_input="'""$1""'"
bill_period=`sqlplus uname/pwd@dbname <<eof!
set verify off
set heading off
set feedback off
select bill_period from bill_period_ref where... (4 Replies)
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Hi Frnds,
I wanto load the data thats in data file with comma(,) delimited.
it throw this errors
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified
Plz look at my file... (3 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
I used the following code
code
select * from tablename where columnname
Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem?
Thanks
Ananth (2 Replies)
Hello,
I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused:
echo Input file list to check:
read filelist
for file in 'cat $filelist.txt'
do
echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >>... (9 Replies)
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
LEARN ABOUT DEBIAN
je::code
JE::Code(3pm) User Contributed Perl Documentation JE::Code(3pm)NAME
JE::Code - ECMAScript parser and code executor for JE
SYNOPSIS
use JE;
$j = new JE;
$code = $j->compile('1+1'); # returns a JE::Code object
$code->execute;
METHODS
$code->execute($this, $scope, $code_type);
The "execute" method of a parse tree executes it. All the arguments are optional.
The first argument will be the 'this' value of the execution context. The global object will be used if it is omitted or undef.
The second argument is the scope chain. A scope chain containing just the global object will be used if it is omitted or undef.
The third arg indicates the type of code. 0 or undef indicates global code. 1 means eval code (code called by JavaScript's "eval"
function, which has nothing to do with JE's "eval" method, which runs global code). Variables created with "var" and function
declarations inside eval code can be deleted, whereas such variables in global or function code cannot. A value of 2 means function
code, which requires an explicit "return" statement for a value to be returned.
If an error occurs, "undef" will be returned and $@ will contain the error message. If no error occurs, $@ will be a null string.
$code->set_global( $thing )
You can transfer a JE::Code object to another JavaScript environment by setting the global object this way. You can also set it to
"undef", if, for instance, you want to serialise the compiled code without serialising the entire JS environment. If you do that,
you'll need to set the global object again before you can use the code object.
FUNCTIONS
JE::Code::add_line_number($message, $code_object, $position)
WARNING: The parameter list is still subject to change.
This routine append a string such as 'at file, line 76.' to the error message passed to it, unless it ends with a line break already.
$code_object is a code object as returned by JE's or JE::Parser's "parse" method. If it is omitted, the current value of
$JE::Code::code will be used (this is set while JS code is running). If $JE::Code::code turns out to be undefined, then $message will
be returned unchanged (this is subject to change; later I might make it use Carp to add a Perl file and line number).
$position is the position within the source code, which will be used to determine the line number. If this is omitted, $JE::Code::pos
will be used.
EXPORTS
"add_line_number" can optionally be exported.
SEE ALSO
JE
perl v5.14.2 2012-03-18 JE::Code(3pm)