Jump to content

Anyone here feel the earthquake?


TTQ B4U

Recommended Posts

  • Replies 51
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

There was an earthquake in my bedroom lastnight before they even told you about it on the news.......OKbye

You dutch-oven her?

 

I know I will, I'l going to take a stroll later on today and walk around campus. :)

I may have to come out for a walk with you.

 

take pics......PLEASE! Walk up and say...."Hey bitch....Putty wants to see ya....strike a pose".

Ahahahahahaha!!!!!!!!!!!!

Link to comment
Share on other sites

LMAO!.....no, but picture a person dipping a tea bag in and out a coffee cup.. You know...the up and down motion.....bingo!

 

Ahahahahahaha!!!! The first thing that came to mind was the pic of the nun and the priest. Ahahahahahaahah!!!!!!!!!!!!!

Link to comment
Share on other sites

I've been writing sql scripts all day.

 

select year,

decode( mod(year, 4), 0,

decode( mod(year, 400), 0, 'Leap Year',

decode( mod(year, 100), 0, 'Not a Leap Year', 'Leap Year')

), 'Not a Leap Year'

) as leap_year_indicator

from my_table

/

Link to comment
Share on other sites

select year,

decode( mod(year, 4), 0,

decode( mod(year, 400), 0, 'Leap Year',

decode( mod(year, 100), 0, 'Not a Leap Year', 'Leap Year')

), 'Not a Leap Year'

) as leap_year_indicator

from my_table

/

 

The one I just wrote:

 

 

declare

cursor outlist is

select int_seq_no from job_queue_run

where to_date(rundate, 'yyyy-mm-dd')

 

cursor inlist is

select jobid from job_queue_list

where status not in ('N', 'S');

 

begin

for jobqrun_rec in outlist loop

delete from job_queue_out

where jobq_seq_no = jobqrun_rec.int_seq_no;

 

delete from job_queue_run

where int_seq_no = jobqrun_rec.int_seq_no;

 

end loop;

commit;

 

for jobqlist_rec in inlist loop

 

delete from job_queue_detail

where jobid = jobqlist_rec.jobid;

 

delete from job_queue_sysin

where jobid = jobqlist_rec.jobid;

 

delete from job_queue_list

where jobid = jobqlist_rec.jobid;

 

end loop;

commit;

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...