oracle and loop question

pavan_test · #1 (**permalink**) 09-28-2006

Hi All,

I have a 2 questions; 1 is oracle and another is korn shell

say TIME=20060928
desired output: 20060927

say TIME=20061001
DESIRED output: 20060930

If i substract one day from 'TIME' i am looking for previous day.

can anyone please suggest me how do i do this is SQL.

i have another question; i am trying to write this is korn shell

KKK=a,b,c,d,e

if [ $KKK == 'a' or $KKK == 'c' or $kkk == 'e' ]; then
echo " i am here
else
echo " i am out"
fi

the above code that i wrote is not working.

can anyone please suggest me

thanks
mark

vgersh99 · #2 (**permalink**) 09-28-2006

Code:

#!/bin/ksh

KKK='a,b,c,d,e'

if [[ "${KKK}" = @(*a*|*b*) ]] ; then
   echo "[$KKK] IS [a,b]"
else
   echo "[$KKK] NOT [a,b]"
fi;

pavan_test · #3 (**permalink**) 09-28-2006

Thanks a bunch

can anyone also please suggest me for the following

this is oracle question

say TIME=20060928
desired output: 20060927

say TIME=20061001
DESIRED output: 20060930

If i substract one day from 'TIME' i am looking for previous day.

can anyone please suggest me how do i do this is SQL.

thanks
mark

pavan_test · #4 (**permalink**) 09-29-2006

Hi All,

thanks to all of you for your suggestions;
this is how I tried

SQL> select to_date('20060928', 'YYYYMMDD') - 1 from dual;

TO_DATE('
---------
27-SEP-06

my desired output in this case is 20060927 but here the output is
coming as 27-SEP-06.

can anyone please suggest me how do I get the output as 20060927

thanks a bunch
mark

anbu23 · #5 (**permalink**) 09-29-2006

Code:

select to_char(to_date('20060928', 'YYYYMMDD') - 1 ,'YYYYMMDD')  from dual;

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Error connecting oracle from inside while loop	Devesh5683	Shell Programming and Scripting	3	05-13-2008 03:48 AM
Ps -ef \| grep oracle question	vishalpatel03	Shell Programming and Scripting	5	02-28-2008 03:09 PM
ORACLE RAC ASM disk question	Eronysis	Red Hat	5	02-18-2008 01:50 PM
while loop question	stepnkev	Shell Programming and Scripting	2	06-01-2007 10:51 AM
Loop question	strike	Shell Programming and Scripting	18	04-13-2005 11:24 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by