Re: Unix - script

Try out the following. wget ftp://user:password@host IP/full path of File/Directory Example :- wget ftp://oracle:[EMAIL PROTECTED]//home/superman/myfile.txt Get back in case of any clarification. Bye Sundar Thomas, Kevin wrote: Roland,Try this by setting up environment variables

Re: SQL LOADER

Hi, I am trying to assign a default value for a column from my sequence and i am unable to do that. How do you give it in the control file? Thanks in advance. Regards Sundar Mercadante, Thomas F wrote: IA, like this: ( col1 char , col_seq test_seq.nextval ) where test_seq

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

Hi, You can try the following :- SELECT REPLACE(FIELD NAME, 'SEARCH CHAR', 'REPLACE CHAR') FROM TABLE NAME Say for example Select Replace(ename, ' ', '_') from emp Bye Sundar John Dunn wrote: I want to display a varchar2 field that contains spaces between words i.e MY NAME, but replace

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

Dear All, Can anyone of you help me for the following. I want to give a generalized SQL syntax for Outer Join for both oracle SQL server. Can I use ANSI Syntax say for example select empno, ename from emp join dept on emp.deptno = dept.deptno (Something like this) Bye Sundar -- Please see

Re: sql help --urgent

Hi, Select a, decode(sign(a), -1, 0, a-1) from Table Name For summing up : sum(decode(sign(a), -1, 0, a-1)) Hope this helps Bye Sundar Ravindra Basavaraja wrote: I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But

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]

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

Re:

Hi, I have given that in Init.ora and also have tried DBMS_SESSIOM.set_nls both not working... can anybody know the solution. Regards Sundar Greg Solomon wrote: My boss tells me that two major projects have come out of Berkeley in the last 50 years. One was BSD; the other was LSD ... go

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