Sponsored Content
Full Discussion: nvl function in lunix
Top Forums Shell Programming and Scripting nvl function in lunix Post 302515184 by imtheone on Tuesday 19th of April 2011 10:46:44 AM
Old 04-19-2011
nvl function in lunix

i wanna write these pl/sql codes in lunix.

pl/sql:
Code:
if pi_start_date is null
then 
  pi_start_date := sysdate;
end if;

unix:
Code:
if [-n pi_start_date] then 
  $pi_start_date=`date +%Y%m%d`
fi;

but this isnt correct.

ty for helps

Last edited by Franklin52; 04-19-2011 at 03:03 PM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How can i know file using another process on lunix shell script?

hi all, I did RedHat OS. How can i know myfile using another process on lunix shell script? Have you got any suggestions? (1 Reply)
Discussion started by: Tlg13team
1 Replies

2. Shell Programming and Scripting

Passing global variable to a function which is called by another function

Hi , I have three funcions f1, f2 and f3 . f1 calls f2 and f2 calls f3 . I have a global variable "period" which i want to pass to f3 . Can i pass the variable directly in the definition of f3 ? Pls help . sars (4 Replies)
Discussion started by: sars
4 Replies

3. Shell Programming and Scripting

Return a value from called function to the calling function

I have two scripts. script1.sh looks -------------------------------- #!/bin/bash display() { echo "Welcome to Unix" } display ----------------------------- Script2.sh #!/bin/bash sh script1.sh //simply calling script1.sh ------------------------------ (1 Reply)
Discussion started by: mvictorvijayan
1 Replies

4. Shell Programming and Scripting

SHELL SCRIPT Function Calling Another Function Please Help...

This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord but only one record is getting wrote in DB.... Please advise ASAP...:confused: function InsertFtg { FTGSTR="" echo "Saurabh is GREAT $#" let... (2 Replies)
Discussion started by: omkar.sonawane
2 Replies

5. Programming

How to step in one function after the function be executed in gdb?

In gdb, I can call one function with command "call", but how can I step in the function? I don't want to restart the program, but the function had been executed, gdb will execute next statement, and I don't know how to recall the function. (4 Replies)
Discussion started by: 915086731
4 Replies

6. Shell Programming and Scripting

Help to Modify File Name in each function before calling another function.

I have a script which does gunzip, zip and untar. Input to the script is file name and file directory (where file is located) I am reading the input parameters as follows: FILENAME=$1 FILEDIR=$2 I have created 3 functions that are as follows: 1) gunzip file 2) unzip file... (2 Replies)
Discussion started by: pinnacle
2 Replies

7. Shell Programming and Scripting

Will files, creaetd in one function of the same script will be recognized in another function?

Dear All. I have a script, which process files one by one. In the script I have two functions. one sftp files to different server the other from existing file create file with different name. My question is: Will sftp function recognize files names , which are created in another... (1 Reply)
Discussion started by: digioleg54
1 Replies

8. Shell Programming and Scripting

Need help on awk for printing the function name inside each function

Hi, I am having script which contains many functions. Need to print each function name at the starting of the function. Like below, functionname() { echo "functionname" commands.... } I've tried like below, func=`grep "()" scriptname | cut -d "(" -f1` for i in $func do nawk -v... (4 Replies)
Discussion started by: Sumanthsv
4 Replies

9. Shell Programming and Scripting

Function - Make your function return an exit status

Hi All, Good Day, seeking for your assistance on how to not perform my 2nd, 3rd,4th etc.. function if my 1st function is in else condition. #Body function1() { if then echo "exist" else echo "not exist" } #if not exist in function1 my all other function will not proceed.... (4 Replies)
Discussion started by: meister29
4 Replies

10. What is on Your Mind?

LUNIX on a Commodore 64, yup UNIX on one of the most famous home computers of all time...

Enjoy guys and gals... LUnix on a Commodore 64... YouTube Bazza... (1 Reply)
Discussion started by: wisecracker
1 Replies
oarnodesetting(1)						   OAR commands 						 oarnodesetting(1)

NAME
oarnodesetting - Change the state and properties of a node in OAR. SYNOPSIS
oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]] DESCRIPTION
This command is used to Change the state and properties of a node in OAR. OPTIONS
-a, --add Add a new resource. -s, --state STATE Set the new state of the node. The available states are: Alive, Absent and Dead. -m, --maintenance on/off Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0). -h, --hostname HOSTNAME Set the node hostname. -r, --resource Set the resource. --sql Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'"). -p, --property "PROPERTY=VALUE" Set the property of the node to the given value. -n, --nowait Do not wait for job ends when the node switches to Absent or Dead. EXAMPLES
oarnodesetting -s Alive -h node012 oarnodesetting -s Absent -h node012 COPYRIGHTS
Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. oarnodesetting 2012-05-23 oarnodesetting(1)
All times are GMT -4. The time now is 10:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy