RE: Making my firts job

>Hi!! >I am making my firts job and I have some problems >calculating the correct = >time to lauch the job. >I have the next procedure: > >CREATE OR REPLACE PROCEDURE SP_SOH_HAND >AS >BEGIN >INSERT INTO TB_ICTRANSX select COMPANY, >LOCATION,ITEM,SOH_QTY,AVERAGE_COST,= > SYSDATE-1, UPDATE_TIME from

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Try copying the contents of the CD to a directory on your hard drive.  Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old.  Then run setup from the directory on your hard drive.   Gudmundur -Original Message-Fro

Re: Forms - as sysdba

Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb -- Pl

RE: Online Document for Windows XP Home edition Severity 3

Title: Message If you have reached a point where you could press the Install/DeInstall button, it means that you don’t have any problem with your Java installation/settings. Try to troubleshoot in other areas. Also, update the Forum with your success story once you are done.   ~Venu  

AW: RH not-so-Advanced 2.1 and new hardware

Hi Rich ! Most of the NICs are NE2000 compatible. This means that you could run your NIC by using the module 'ne2k-pci.o' in '/lib/modules/$KERNEL_VERSION/kernel/drivers/net'. (on RH9 or RG AS2.1) I am using this module at home to run my RT8139 NIC under RHAS 2.1 HTH. Milen -Ursprüngliche

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Sinardy,   I've installed the Oracle docs simply by copying all the directories from the CD to my hard drive - no need to perform an installation.   Hope this helps.   Tom Mercadante Oracle Certified Professional -Original Message-From: Gudmundur Bjarni Josepsson

RE: Making my firts job

Simple:  TRUNC(SYSDATE) + 1 + 1/60/60/24   TRUNC(SYSDATE) is midnight today. +1 is midnight tomorrow. +1/60/60/24 is one second past midnight - 1/60th of a minute, which is 1/60th of an hour, which is 1/24th of a day. -Original Message-From: Teresita Castro [mailto:[EMAIL P

Oracle 9i versus MS SQL 2K w.r.t. Performance

  Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily .   Any Docs , Links ?   Thanks    

Re: Row level security and latch waits - LONG email...

- Original Message - > Policy function: > DPA42HP92.DP_PREDICATE_FUNCTION_PKG.DP_PREDICATE_FUNCTION > RLS view : > SELECT "CURRENCY","CURRENCY_CODE","CURRENCY_DESC","CURRENCY_KEY" FROM > "DPA42HP9 > 2"."DPR70_CURRENCY_D" "DPR70_CURRENCY_D" WHERE (CURRENCY_CODE in (select > value_ > v >

Re: Nature of Oracle-l has changed

Jared, I agree that the development has declined at a lot of sites. We are a VB shop and damagement has decided to outsource the hosting of our reports database and the web based development of the application to access the reports database. I soon will go from a 84 GIG database to a 5 GIG databa

RE: SharePlex info

Title: Message Tony,   My question was inspired by belief that SharePlex does log mining on the source DB and hence do not send unnecessary data over the network. Apparently, this is not the case. I didn't want to compare SharePlex to logical standby cause I know that logical standby defi

Business Rules approach to design?

I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent really read that much into it. It also appears that the level of skill and experienc

RE: Oracle 9i memory Leaks and other errors

anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues su

RE: RH not-so-Advanced 2.1 and new hardware

Thanks for the suggestion! Since our RAC tests have two main goals -- to test RAC functionality and to test it on RH AS 2.1 -- I've temporarily given up on AS 2.1 and installed RH9 instead. Of course with the newer kernel and more mods included, it installed easily without a problem. I'll be sav

OT: Mysql & PHP list

Title: OT: Mysql & PHP list Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack

+++ Oracle + RAID +++++++++

Dear Friends, I have read some book to know about Oracle on RAID. I better idea about various RAIDs. But Implementing Oracle on RAID , I am not much clear. My understaning is 1. All files on RAID 1 +0 ( because its good in IO rates, better protective ) 2. Read only TS on RAID 5.(because its rea

UNIX and Oracle

Dear Friends, Any good article to explain the above subject, SHARED Memory & Sema phores on SUN / LINUX for Oracle. I just know what is shared memory , sema phores are. But never involved practically much. Please also send me some typical configurations , with explanation(if possible ) Please sen

RE: Oracle 9i memory Leaks and other errors

You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -Original Message- Bhavesh Lala Sent: Friday, August 22, 2003 10:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003

Re: Nature of Oracle-l has changed

- Original Message - > > Times are changing and the dinosaur will become extinct if the don't > become like a shark.. > I think development has certainly declined, when compared to the hefty levels of pre-Y2K prep. However, it's not any less or more than it was back in the late 80s,

RE: Nature of Oracle-l has changed

That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as

Re: OT: Mysql & PHP list

Jack, if you've got some specific questions shoot them my way, i'm doing php/mysql development right now for dynamic web pages. joe Jack van Zanen wrote: Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack -- Joseph S Testa Chief Techn

RE: Business Rules approach to design?

I have a growing respect for the business rules approach to system design. For instance, entities and relationships as drawn in a traditional entity/relationship (E/R) diagram are representations of business rules about what data your system will read, update, store and write and how various pi

Re: Collaboration Suite

> switch back to regular fileserver which I now know should be used for > serving files anyway. In the future of course, 'regular' file servers will actually be running on top of a database. SQL Server if your file server happens to be of the M$ variety. Will SysAdmins also need to be DBA's? ;)

Re: Business Rules approach to design?

And I thank you. :) On Fri, 2003-08-22 at 06:49, [EMAIL PROTECTED] wrote: > I know this is big in the ODTUG circles. Has anyone used this approach to design > databases? Seems promising. Though the hardest part would be in convincing the 'i > just want to code' folks to adapt it. > > I havent

Exact fetch

Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Oracle 9i memory Leaks and other errors

I have tried there and they just have a patch but not much other info which can help -Original Message- Sent: Friday 22 August 2003 04:20 To: Multiple recipients of list ORACLE-L You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -O

RE: Exact fetch

Title: RE: Exact fetch it means "Exact fetch returns more than requested number of rows", nothing more, nothing less. HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are st

RE: Exact fetch

What does the load procedure look like? AFAIK this means that a select into returns more than one row in the subquery, which would indicate use of PL/SQL Any triggers etc..?? Jack -Original Message- Sent: Friday, August 22, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Hal

Re: Oracle 9i versus MS SQL 2K w.r.t. Performance

The Yukon Database     Try this link http://www.oracle.com/features/insider/index.html?1101_db_yukonlate.html and http://www.oracle.com/ip/deploy/database/oracle9i/db_sqlpartners.html   Alessandro Guimarães - Original Message - From: VIVEK_SHARMA To: Multiple recipients of l

Re: Exact fetch

7:24-sherlock:ts01:jkstill-0 > oerr ora 1422 01422, 0, "exact fetch returns more than requested number of rows" // *Cause: The number specified in exact fetch is less than the rows returned. // *Action: Rewrite the query or change number of rows requested 07:25:43 sherlock - [EMAIL PROTECTED]

Partitions in RH AS 2.1

Title: Partitions in RH AS 2.1 Hi list, New in linux. I configured a RAID 0 in a Dell Server and installed RH AS 2.1.  Now as a result I have a /dev/sda4 of 200 GB. I used fdisk and made 3 partitions that became /dev/sda9, /dev/sda10, /dev/sda11. Now I want to make the file systems and mo

Re: RE: Business Rules approach to design?

i head paul dorsey(from dulcian) speak last night. he was talking about a business rules repository modeller that his company has called 'BRIM' supposed it will generate the bulk of the code for you. anyone ever work with that? > > From: "John Flack" <[EMAIL PROTECTED]> > Date: 2003/08/22 Fri

Oracle on RAID - Thanks

To whomever posted the link to Gaja's paper Implementing RAID on Oracle - thank you. I previously had printed and passed this article on to my system administrator -- no reaction. But yesterday he was building our new Sun system with all the latest features, and was so excited about the paper that

RE: Oracle 9i memory Leaks and other errors

Are you sure it is a memory leak or is it problem with program design? What are the error messeges? Bit tough to provide any feedback with the minimal information you have provided. Brad O. -Original Message- Sent: Friday, August 22, 2003 9:09 AM To: Multiple recipients of list ORACLE-

HP-UX 11/9iR2/Processes

Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PRO

RE: Oracle 9i versus MS SQL 2K w.r.t. Performance

Vivek - This subject has been discussed on this list from time to time. You can go to Google and search for Oracle-L "SQL Server" and variations to pull up previous discussions. Awhile back eWeek magazine did an extensive benchmark. It is a little date, but make sure you re-read that for insights.

RE: Nature of Oracle-l has changed

There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become "compliant with present standards". That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CR

RE: Nature of Oracle-l has changed

Jared, Yes, the nature of the list has changed, so have the times. While development work here is not slowing, the direction that we're going in has changed. Oracle's development tools are just about history here replaced by PeopleSlop and JAVA. Also I've spent a significant amount o

RE: Nature of Oracle-l has changed

OK, who let "Chicken Little" out of his room?? As someone at a location that is doing a lot of third party application buying, yes we in some ways are crane operators and mechanics. But then comes the fun of integrating the data from that new application into the remainder of th

RE: Nature of Oracle-l has changed

It also seems that once the big canned application are up and running, companies are outsourcing more and more the operations. Those canned applications need to be integrated and that's the best and last place where DBA and dev people can be today, in the BI place. Here, in the architecture princ

Re: Oracle on RAID - Thanks

>Of course, the Sun engineer is saying "our new RAID 5 is just as fast as > RAID 10 because we stripe parity across all disks". Uh huh. Does he think this is new? RAID 3 is the version that has a dedicated parity disk IIRC. RAID 5 has always striped the parity across all disks. Jared On F

Re: HP-UX 11/9iR2/Processes

It is the snp equivalent ...in 9i rel2 there is a job coordinator process and based on the job_queue_processes parameter ...that many jnnn processes. Murali.

RE: (long) Design question, historic and views

Hi! To answer your original question about the design & DW transport, there is too much to write to answer it completely. There's too many different ways to do the task. I'll try to give you a reply from my past experience with OLTP-> DW transfer (from up to 800GB OLTP systems to 2-3TB DWs). 1) L

AW: Nature of Oracle-l has changed

Hi Stephane Looks like I missed that post amongst all the "very" technical ones ;). I'm working on a development project now (social security), which includes heavy modelling, especially in the arena of historical data etc. So, it looks like I have to go back and browse the archive for your posti

RE: RE: Nature of Oracle-l has changed

Mladen, >There is another thing happening: companies are >more and more relying on >canned, >off the shelf applications, in a hope to become >"compliant with present >standards". >That has dramatically cut down the number of needed >developers, because if >you don't >have to develop your general

AW: Nature of Oracle-l has changed

Hi Mladen I guess you summarized the whole drama of "IT today" pretty well. I'm already VERY concerned about the near future (esp. as a former developer, now more DBA/Data Manager guy). What's left to do, or to concentrate on, when development will be shipped to elsewhere and DBAing means "Hey Joe

RE: Forms - as sysdba

Title: RE: Forms - as sysdba What about granting sysdba priviledge to yourself? then you could do everything sys could do!   my 0.02   Luis -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 6:19 PMTo: Multiple recipients of list

time/date granularity

Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.c

RE: Making my firts job

Thanks  !! A friend of mine give an example of how to do a procedure that runs a job:   CREATE OR REPLACE PROCEDURE lanza_job IS     jobno number;  instno number;    begin dbms_job.submit( jobno, 'SP_SOH_HAND;', TRUNC(SYSDATE) + 1/60/60/24 ,'TRUNC(SYSDATE) + 1 + 1/60/60/24 ');   commit;

ADMIN: Collaboration Suite mailing list?

Hi group -- I've been toying with starting a new mailing list for Oracle Collaboration Suite (OCS) users and administrators. It's a fairly new product and I haven't seen any mailing lists other than what is on OTN, so there might be a need. I realize that participation might be low as the lis

RE: RE: Nature of Oracle-l has changed

There is another "problem" with canned applications. The damanagement has to make a choice to either bend the business to match the application of bend the application to match the business. From my point of view, the latter is happening more than the former. Also, as a side note, I b

RE:OT:UNIX: Anyway to run this in the background and return to ca

Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process $ORACLE_HOME/bin/sqlplus "/ as sysdba"  << EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and

RE: time/date granularity

Josh - Which Oracle version? I think 9i has provision for this. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 22, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way for me to get the time of a pa

RE: Nature of Oracle-l has changed

Do you see outsourcing orientation to the canned products in Germany? I imagined that Siemens, Software AG, MBB (Airbus) and some other companies must be doing heavy development there, and that, given the language barrier, the supply for the off the shelf products is not as good as here in the US.

RE: Nature of Oracle-l has changed

Well...I made the transition from development to DBA when we initially got "SAP'd" (1993) partly because it looked interesting, partly because I was the only one on the development staff who bothered to dig into the technical end of things and...partly because management at the time had this over

RE: time/date granularity

Title: RE: time/date granularity if you are pre 9i you can get up to 100th of a second using dbms_utility.get_time(). in post 9i, you can use systimestamp which will give you a microsecond if you wish. Raj Raj

RE: OT:UNIX: Anyway to run this in the background and return to c

Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process Never mind I got it. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UN

RE: time/date granularity

Sorry I left out the important thing: 9i rel 2. Thanks. -Original Message- Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Josh - Which Oracle version? I think 9i has provision for this. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTE

RE: time/date granularity

Title: RE: time/date granularity The issue at hand is this:   There is a column, setup_date that is populated by a trigger with sysdate after insert. Now the developers want to know if there is a way they can get the time of this date to a granularity of 10ths or 100ths of a second.   If I

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n";   waitpid($pid,0);   print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sql

RE: time/date granularity

Title: RE: time/date granularity Josh,   sysdate has the granularity of a second only. You might want to add a new column for fractional seconds or change the column datatype to systimestamp;   if you create new column, you can just add the fractional part as follows ...   create or replace t

Re: time/date granularity

Title: RE: time/date granularity You can't even store sub second precision values in date datatype. Use timestamp instead (9i) or some custom format. In 8i you can have a java class which returns you date with high enough precision.   Tanel.   - Original Message - From: Josh

Kerberos OKINIT , OKLIST, ORA-12699

I'm trying to get Kerberos authentication to work. I am not using LDAP at all. I just want to authenticate with Kerberos. Kerberos itself is working fine. "kinit" and "klist" work as expected. I had our security admin create a service principle. Does there have to be one per machine or one

RE: Nature of Oracle-l has changed

> I believe the mantra needs to be "evolve and prosper, stagnate and die". I've been thinking along much the same lines. Jared "Goulet, Dick" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  08/22/2003 09:09 AM  Please respond to ORACLE-L                 To:        Multiple recipients

RE: (long) Design question, historic and views

Thanks for sharing.  It may have been 'back in the 8.0 days', but is nonetheless a clever process. Streams and Logminer may be available now, but I like the elegance of the dual partition exchange. Jared "Tanel Poder" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  08/22/2003 09:34 AM  P

RE: Kerberos OKINIT , OKLIST, ORA-12699

With kerberos, you shouldn't do "identified externally", you should do "identified globally". And yes, gooey tools are just for wimps. Real programmers use "ed". -- Mladen Gogala Oracle DBA -Original Message- MacGregor, Ian A. Sent: Friday, August 22, 2003 3:14 PM To: Multiple recipien

ADMIN: Warning about virus threats this week

Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three tim

RE: RE: Nature of Oracle-l has changed

Well, I wanted to add my .2 Cents here. Custom development projects have shrunk over the past year because companies are tired of the maintenance issues associated with custom applications. More organizations are shifting their efforts towards implementing "canned" solutions and taking the bite, a

RE: (long) Design question, historic and views

Hi, Thanks for the info. Our site is way smaller, the ODS will be around 30G of raw data. So partitionning is out of the question here (I've used the one partition table trick to use the exchange feature before on a bigger db). Management is even considering DB2 for all the BI initiatives since t

SharePlex info

Title: Message You are correct in the first place.  SharePlex works as you describe, it mines the log and sends only the absolute minimum to reassemble the transaction on the target.  It doesn't send SQL.  The target side processes take the data and rebuild a SQL statement from the DDL defin

RE: Forms - as sysdba

Hi Bruce, this is EXACTLY what I needed, great! Many thanks =RP= > Hi > > I don't have 9i to test, but I believe you might be able to > set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then > you should be able to connect as sys without specifying sysdba. > > This might be suitable for

RE: OT:UNIX: Anyway to run this in the background and return to c

Title: Message Thanks,   Hmmm perl... Well, I came up with a loop using while and a ps -ef|grep $pid command but this looks interesting.  -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 2:04 PMTo: Multiple recipients of list ORACL

RE: Nature of Oracle-l has changed

Evolve and prosper may mean leaving IT work   Here are some other possibilities:   1. Open your own pub 2. Become a carney - (Hard work but you get to party ALL THE TIME) 3. Enter Damagement (If you like that) 4. Go back to school (Art, theology, history, science use your gifted brain

convert number to word ???

Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see t

RE: Nature of Oracle-l has changed

Title: Message I'm planning on doing #4 next fall. Look out Mississippi State, here I come!   Kevin Toepke -Original Message-From: Odland, Brad [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Nature of

RE: Nature of Oracle-l has changed

We are in the middle of a development revolution here. It is being driven by a desire to allow greater access to the Peoplesoft databases. The Peoplesoft folks want to continue using those tools. But the folks that are responsible for the application server which will connect to Psoft want to

Re: ADMIN: Warning about virus threats this week

Thanks for staying on top of this Bruce. Jared "Bruce A. Bergman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  08/22/2003 12:39 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:    

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message   Errrm - this script doesn't do what I think you're trying to do.  Perl starts, it forks a child process, the parent process "does a bunch of stuff", but the child process only runs ps once. S, you end up with a zombie child process (until the parent is done with its bus

Re: convert number to word ???

some where I got this create or replace function spell_number( p_number in number ) return varchar2 as type myArray is table of varchar2(255); l_str myArray := myArray( '', ' thousand ', ' million ', ' billion ', ' trillion ', ' quadrillion ', ' quintillion ', ' sextillion ', ' septillio

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message No, I just wanted to demonstrate the fork mechanism in perl. The proper way to handle stuff would be to call exit at the end of the child process, which would clean things up properly and not leave za zombie lying around. And yes, "ps -ef" is executed only once, when the SPY

RE: Kerberos OKINIT , OKLIST, ORA-12699

I'm using externally because I am not using a directory service. Ian -Original Message- Sent: Friday, August 22, 2003 12:42 PM To: Multiple recipients of list ORACLE-L With kerberos, you shouldn't do "identified externally", you should do "identified globally". And yes, gooey tools a

RE: convert number to word ???

You can find perl module doing that at: http://www.bayview.com/software/perl.shtml -- Mladen Gogala Oracle DBA -Original Message- Andrea Oracle Sent: Friday, August 22, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Hi, Is there a function that can conver number to word? ef:

Re: convert number to word ???

I got this off of metalink:   select to_char( to_date( &&1, 'J' ), 'jsp' ) from dual;   SQL> select to_char( to_date( 123,'J'), 'jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- one hundred twenty-three   SQL> select to_char( to_date( 123,'J'), 'Jsp') from dual; T

Re: convert number to word ???

SELECT TO_CHAR(TO_DATE(2003,'J'),'JSP') FROM DUAL; TO_CHAR(TO_DATE(20 -- TWO THOUSAND THREE - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 22, 2003 4:19 PM > Hi, > > Is there a function that can conver number to

RE: OT:UNIX: Anyway to run this in the background and return to ca

Title: Message   Oh, I see - okay, I just misunderstood what was being demonstrated.  You can't simply call exit at the end of a child execution, however - you must either terminate the parent process or call wait(), waitpid(), etc.   exit() will leave a zombie until the parent waits() for a

Re: ADMIN: Warning about virus threats this week

I think its a GREAT IDEA!  Thank you for maintaining this list and keeping it virus free, well almost :).  Other lists, I belong to are slamming me w/ the SOBig virus. Gene>>> [EMAIL PROTECTED] 08/22/03 03:39PM >>>Hello everyone --As you undoubtedly know, the Internet has been slammed this w

Re: ADMIN: Warning about virus threats this week

Bruce A. Bergman wrote: Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact

RE: Oracle World anyone?

All, I having taken on co-ordinating the Oracle-l listers get-together at OOW this year (Sep 7-11). So far, I have Jonathan Gennick, Matt Adams, Brian McGraw, Gerardo Molina and self. If any of you are considering a visit to the Bay area at that time - OOW or otherwise - you are welcome to attend.

RE: Oracle World anyone?

I will be there too and looking forward to seeing everyone again. -Ari Ari Kaplan CEO, Expand Beyond www.XB.com Worldwide Leader in Mobile Software for IT Management Maximize Performance and Productivity Beyond the Desktop e| [EMAIL P

RE: convert number to word ???

-Original Message- AK Sent: Friday, August 22, 2003 3:09 PM To: Multiple recipients of list ORACLE-L >some where I got this > >create or replace >function spell_number( p_number in number ) >return varchar2 >. >. >. That is the same routine i was directed to a few months back when I a

Re: convert number to word ???

This trick is rather limited, as it runs out of steam at amounts somewhat greater than my salary. Best go to asktom.oracle.com for this, I recall seeing a rather good one there that had much higher limits. Jared "Shannon St. Dennis" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  08/22/

RE: OT:UNIX: Anyway to run this in the background and return to ca

Here's a rather standard way of doing a fork in Perl. Also a nice little daemon.  Works very well for Oracle utilities. Jared > package Daemon; > use strict; > use Carp; > use POSIX; > sub daemon { >   my($tries, $pid, $sess_id); >   { >      if ($pid = fork) { exit 0 }   # exit parent >      

Recover 8.1.7 DB with _allow_resetlogs_corruption

8.1.7.0 on HP-UX. Another DBA (really, it wasn't me) forgot which server he was on and deleted the RBS tablespace datafile and all the archived redo logs - on different mount points - of our Production Financials database.  No time for the whys of that story or why we don't mirror our archived re

9iR2, grant select on a column (without using views) using RLS

list, i'm ikn the process of designing security for a highly sensitive schema for a bank, plan: have multiple oracle users, and use roles, and grant minimum required privs, all the user/role/privs management coded in the application (with in turn would create the db role and user etc) probol

Replication options Was: SharePlex info

Hi there In the past few weeks, there have been lots of discussion about HA, data replication and using Shareplex, dataguard, Streams, logical & physical standby.  As most of you have found out each has it own pros and cons.  You also need two sets of Database licences and Shareplex licences.  Th