Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

nvl function in lunix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting nvl function in lunix
# 1  
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
# 2  
Old 04-19-2011
Code:
if [ -z "$pi_start_date"  ] ; then 
$pi_start_date=`date +%Y%m%d`
fi

Note the spaces around the [ and ]

fixed typo.
Last edited by jim mcnamara; 04-19-2011 at 12:08 PM.. Reason: typo
# 3  
Old 04-19-2011
Hi imtheone ,

test -n returns true when the length of the tested string is nonzero, and there are some other issues with your code.
Try this:
Code:
if [ -z "$pi_start_date" ]; then
   pi_start_date=`date +%Y%m%d`
fi

# 4  
Old 04-19-2011
@jim mcnamara
i got syntax error about fi
ty for help

@cero
ty so much.
it is correct.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question