|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Pass a variable string in To_Date Oracle function in shell script
Post 302893679 by Corona688 on Thursday 20th of March 2014 01:18:30 PM
03-20-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have two shell variables $t1 and $t2 which I need to pass to a function in a shell script. The function will do some computation with those two variables and echo the resultant. But I do not know how to pass teh arguments.
The function written is
f1()
{......
........
}
What should... (3 Replies)
Discussion started by: preetikate
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am calling an oracle function that returns a number (either 0 or 2), how do I pass that pass to the wrapping shell script as I would like to do other things based on the value returned by the oracle function.
Your help will be appreciated.
--------------------------
sqlplus / <<... (3 Replies)
Discussion started by: Jtrinh
3 Replies
3. Shell Programming and Scripting
what is the maximum number of parameter we can pass to a shell script function (8 Replies)
Discussion started by: alokjyotibal
8 Replies
4. Shell Programming and Scripting
Hello,
Can anyone guide me tin passing parameters into user defined function of shell script (KSH).
Here is my code,
InsertRecord()
{
DB_TBL=$(sqlplus $USERID/$PASSWORD@$DATABASE << EOF
set head off
set feed off
set serveroutput on
INSERT INTO TBL1 ( OLD_VAL,
NEW_VAL,
... (7 Replies)
Discussion started by: Poonamol
7 Replies
5. Programming
Hello,
I am writting a procedure in shell script as,
set serveroutput on
declare
date_gen DATE := $DATEGEN;
begin
INSERT INTO TBL1 ( EMPNAME,EMPID,EMPBDATE)
VALUES($EMPNAME,$EMPID,TO_DATE(date_gen,'YYYY-MM-DD'));
end;
/
Where DATEGEN is unix string variable which I need to use into... (10 Replies)
Discussion started by: Poonamol
10 Replies
6. Shell Programming and Scripting
hi,
I have a array say
SAP_ARRAY="s1.txt"
SAP_ARRAY="s2.txt"
how can i pass this full array to a function.
here is the sample code i am using..
CHECK_NO_FILES()
{
FARRAY=$1
echo "FARRAY = $FARRAY"
echo "FARRAY = $FARRAY"
............... (5 Replies)
Discussion started by: Little
5 Replies
7. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
8. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
2. Relevant commands, code, scripts, algorithms:
#! /bin/ksh
v="ORG_ID"
... (2 Replies)
Discussion started by: sujitdas2104
2 Replies
9. Shell Programming and Scripting
Shell script to pass the config file lines as variable on the respective called function on a script
I want to make a config file which contain all the paths.
i want to read the config file line by line and pass as an argument on my below function.
Replace all the path with reading config path line by line and pass in respective functions.
how can i achieve that?
Kindly guide.
... (6 Replies)
Discussion started by: sadique.manzar
6 Replies
10. Shell Programming and Scripting
I'm able to read & print an array in varaible called "filelist"
I need to pass this array variable to a function called verify() and then read and loop through the passed array inside the function.
Unfortunately it does not print the entire array from inside the funstion's loop.
#/bin/ksh... (5 Replies)
Discussion started by: mohtashims
5 Replies
LEARN ABOUT PHP
ncurses_init_color
NCURSES_INIT_COLOR(3) 1 NCURSES_INIT_COLOR(3) ncurses_init_color - Define a terminal color SYNOPSIS
int ncurses_init_color (int $color, int $r, int $g, int $b) DESCRIPTION
Defines or redefines the given color. When this function is called, all occurrences of the given color on the screen, if any, immediately change to the new definition. Color capabilities must be supported by the terminal and initialized using ncurses_start_color(3) prior to calling this function. In addi- tion, the terminal must have color changing capabilities; use ncurses_can_change_color(3) to check for this. PARAMETERS
o $color - The identification number of the color to redefine. It may be one of the default color constants. o $r - A color value, between 0 and 1000, for the red component. o $g - A color value, between 0 and 1000, for the green component. o $b - A color value, between 0 and 1000, for the blue component. RETURN VALUES
Returns -1 if the function was successful, and 0 if ncurses or terminal color capabilities have not been initialized or the terminal does not have color changing capabilities. SEE ALSO
ncurses_color_content(3), ncurses_start_color(3). PHP Documentation Group NCURSES_INIT_COLOR(3)