DBMS_JOB Help

Dear All, Can anyone tell me how to find out currently running jobs initiated thru DBMS_JOB package? Thanks Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

DBMS_JOB Help

Hi All, Can Anyone tell me how to stop a background job initiated through a DBMS_JOB package when it is no longer required? Thanks in advance. Regards Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City

Re: sqlplus formatting question

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network

urgent..! ANSI Standard SQL for Outer Join (ORACLE SQL SERVER)

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: sql help --urgent

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How set Date format Globally

that in the login.sql it worked fine for my every client session. How can I set it globally so that everytime when I make a session to database from any client It should be '-mm-dd hh:mi:ss'. Regards Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar

[Fwd: How set Date format Globally]

Hi, I have a requirement. Everytime when i make a session to the database i want the Date Format to beas follows '-mm-dd hh:mi:ss' The existing default format is 'dd-mon-' and so I tried the following steps. ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in

Re:

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Linux profile - a little offtopic

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL

Work around for PL/SQL code

Hi, Let me introduce myself. I am Rangachari Sundar from Chennai India. I have the workaround for the requirement you have posted and here it is vPOSTAL_NO := lpad(replace(trim(recCursor.POSTAL_NO), ' ', ''), 7, '0') ; Trim is not available prior to oracle 8 so if your version is prior to 8