Re: ORA-24314 service handle not initialized

i am using Solaris 8 Release 4/01. ang i used the latest recommend patch. so this must be the problem even if i used Oracle 9.0.1. Stephane Faroult wrote: paPIpapupapePO wrote: > > hi! > > every time i start Oracle9i this > error appears in my screen. > i dunno how to fix this. > unfortunately, m

Re: ORA-24314 service handle not initialized

paPIpapupapePO wrote: > > hi! > > every time i start Oracle9i this > error appears in my screen. > i dunno how to fix this. > unfortunately, my first time > to use Oracle. > > thanks in advance. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- Must be something wrong

RE: ORACLE9i(Init.ora)

Sure, undo_tablespace is another!!! Actually, there are quite a few new init.ora parameters in 9i besides the ones you mentioned. We are still testing 9i and have not encountered any problems. There is a patch (9.0.1.2) that fixes a nasty bug related to Auto Undo Mgmt. I recommend applying it

RE: How to duplicate production database onto development box

Hi Waleed, I am not sure about other applications but for Oracle HRMS Applications, I am afraid it's so. For example, refer to metalink Note 117012.1 Viewing Reports in 11I Applications & ADI 7.0. In this article, you will realize that the machine name is hardcode in the column FND_CONCURRENT_QU

ORACLE9i(Init.ora)

Hi Is any specific init.ora parameters for Oracle9i Database except UNDO_MANAGEMENT and Dynamic SGA? if some one installed oracle9i on production site then let me know How is oracle9i runing?Is any specific problem you are facing? Thx -Seema __

RE: NUMBER of PROCESS

sounds like a possible semaphore problem if this is Unix system. In other words, you need to increase the number of semaphores (your sysadmin does this) and then reboot the system what is the exact error you get when you try to start the database? --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrot

RE: hang-up

Pipo, I used to get this all the time with DBCA on NT. It should be creating a log file, I don't remember where, but I think its the same place as the oracle installer does. This happened so much to me, that when I do use DBCA now, instead of having it create the database, I have it just gen

RE: How to duplicate production database onto development box

This will be ridiculous to hardcode this kind of information. So if my system crashed and I had to import a full export into a new machine, it's not going to work?!! I do not believe this could be true. Waleed Any views or opinions presented in this email are solely those of the author and do

hang-up

i cant finish creating a database. i use tha Oracle Database Configuration Assistant. when it reaches the part that Oracle instace is able to start in this procedure, the process seems like stalling or hanging. but no error dialog appears. i dunno the cause. my OS is solaris. thanks in advance.

RE: NUMBER of PROCESS

What error did you get? Is this on UNIX server? - Kirti -Original Message- Sent: Wednesday, March 27, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Hi, When I change the number of process, I mean increase it is there are any other paramter related to this one or not, becaz a

RE: How to duplicate production database onto development box

Hi, Does anyone know whether I could duplicate the Oracle HRMS Applications using the same methods as described ? I understand that some of the Oracle Applications tables hardcode the server name etc. Has anyone done it before ? I need to migrate my production Oracle HRMS Apps database to a more

ORA-24314 service handle not initialized

hi! every time i start Oracle9i this error appears in my screen. i dunno how to fix this. unfortunately, my first time to use Oracle. thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services

Re: Questions about AUDIT

Here's my all purpose 'Where the heck is that and what is it called?' sql script. I find it quite useful for times when I think theres an object in the database that I want to see, but am not quite sure about it's name. Jared e.g. @finobj audit -- findobj.sql col cobject noprint new_value

Re: PL/SQL - procedure

Jan, It isn't necessary to be insulting. If you don't like reading or answering his posts, just delete them. Jared Jan Pruner <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/26/02 04:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT

RE: Oracle Wants Users to Hand over Apps Management

Really? I've heard the same thing. Spent a *lot* of time with 9.x versions a few years ago. I have a 10.7 system here. It's pretty small, and HR only, but I never do anything with it other than make sure it's up. It's had zero maintenance from an apps perspective since I've been here. ( June

RE: hotbackup script for NT OR WIN2000

You have a point Brian, however backup and recovery is the heart of a dba's job. This skill is not something that is just taken from someone else's scripts and that's good enough - it's something that each dba should have intimate knowledge of in their specific environment. I am not saying I kno

RE: hotbackup script for NT OR WIN2000

Ya know, I enjoy a good RTFM as much as the next guy, when done properly and for the right reasons. But the number of them that I have seen in the last few weeks is just not justified. Can we all be just a bit more constructive ... Hm Brian P. MacLean Oracle DBA, OCP8i

Re: Long running SQL Problem? [stupid alternative to NOT IN]

ORACLE-L Digest -- Volume 2002, Number 086 > From: Denham Eva <[EMAIL PROTECTED]> > Date: Wed, 27 Mar 2002 10:58:23 +0200 > Subject: Long running SQL Problem? ... > Is there anyone who can give me a solution to this problem. get faster/more RAM, CPU, hard drives, etc? > It is a sql that runs

RE: bulk collect in 9i

IMHO, it still does. You can find other ways to simulate bulk collect though. Checkout tom kyte's site. www.asktom.oracle.com I have posted the excerpts below. What about this then (you still have to create the object type with all 50 columns, NO ESCAPING that) ops$[EMAIL PROTECTED]> create or

RE: Oracle CPU Licensing

Dennis, This doesn't sound right. Oracle will not try to extort, er, charge money for CPU's that aren't installed. Merely having the slots doesn't count. Having CPU's installed but switched off but installed is not a new concept, having been around in the mainframe world for some time. I wou

FUNCTION.

HI LIST, I need some help to write a function or procedure to insert into a table, the input of this function will be a comma delimiter string like (aaa,bbbc,d,f,ggg) and the the result would be 4 records inserted into the table.the number of input could be diffrent. tableA

Re: HOW OLE

[EMAIL PROTECTED] wrote: > C'mon, SOMEONE has to have a good response to this one. LOL ain't nobody here but us chickens.;-) > > >>-Original Message- >>From: Seema Singh [SMTP:[EMAIL PROTECTED]] >>Sent: Wednesday, March 27, 2002 4:26 PM >>To: Multiple recipients of list ORACLE-L

RE: HOW OLE

If you're running Microsoft SQL Server, then you can be sure it is installed in the database. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: Seema Singh [SMTP:[EMAIL PROTECTED]]

Re: STATSPACK

Reddy, Bjorn Engsig wrote a white paper about statspack. Download it from http://www.oraperf.com/whitepapers.html ("Getting fast results with STATSPACK") Anjo. "Reddy, Madhusudana" wrote: > Hello ALL, > I have set up the statspack on Oracle 8.1.7 and just now I also got the > REPORT , but poo

RE: Off Topic: PGP

Tell your vendor it is none of their darn business what you use. :) Would they object to you using Apache? or Linux? open source software should not have any stigma associated with it. Ask them for specific reasons why they don't like it. gpg works fine. BTW, A single user license of PGP s

RE: HOW OLE

C'mon, SOMEONE has to have a good response to this one. LOL > -Original Message- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, March 27, 2002 4:26 PM > To: Multiple recipients of list ORACLE-L > Subject: HOW OLE > > Hi > How we can know whether OLE is installed

RE: Long-running SQL

Cherie, Are you calling this sql for every row in the load job? If the answer = Yes then my advice will be bulk loading in temporary table and joining the temp table with your dim using a Hash/join to load the target table. Do full table scan from the dim table for the join. Regards, Waleed --

HOW OLE

Hi How we can know whether OLE is installed in database? Thx -Seema _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: See

RE: Off Topic: PGP

I think Network Associates has dropped PGP development and will provide support only now. Rich -Original Message- Sent: Wednesday, March 27, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Ok, I did a little more research and I still need help. Our vendor would prefer we not us

Re: Off Topic: PGP

Hi Beth, Contrary to popular belief, open source software is usually considered _much_ more secure than the non-freeware, especially when it comes to encryption. Most of the most secure encryption algorithms are free and public, thus their strength derives from mathematical proofs and not from ob

RE: Off Topic: PGP

Have you tried such sites as http://web.mit.edu/network/pgp.html which says lets you download pgp for non-commercial uses. -Original Message- Sent: Wednesday, March 27, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Ok, I did a little more research and I still need help. Our

Re: spfile mystery on 9i

If parameters cannot modified online, then you can added into your normal init.ora file and recreate spfile again. Did you try create pfile='path/init.ora' from spfile; Joan Stefan Moeding wrote: > > Hi! > > I have setup 9i as a 2 node RAC configuration on Tru64 5.1. The switch > from norma

Re: Long-running SQL

[EMAIL PROTECTED] wrote: > > We have a statement that I feel takes too long to run in a nightly data > load. > The table it runs against has 386,000 records. It runs for about 10 > seconds > on average. We're only loading about 50,000 records a night but this > statement > is running during th

RE: Long-running SQL

Could you please let me know the Title and Author's complete name. I interested in reviewing this book. Srini -Original Message- Sent: Wednesday, March 27, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Yep, Guy's book is among my fav's. I consider it an indispensable DBA book.

RE: hotbackup script for NT OR WIN2000

c:\winnt\system32\rtfm perhaps? -Original Message- Sent: Wednesday, March 27, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Hi Can some one send me hotback scripts for NT OR WIN'2000? With regards Seema _ Join th

client/desktop management from network / was: Re: Net 8 installation on a server

consider an alternative (maybe for future): use the network to standardize desktop settings, but not to store/run the executable. there is software that will "vacuum" custom client/desktop settings from the network side, and allow you to deploy those settings (elsewhere). sort of like "Ghost

RE: bulk collect in 9i

Yes, that limitation still exists in Oracle 9i, R1. -Original Message- Sent: Wednesday, March 27, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Hello, In 8i, the BULK COLLECT and FORALL commands are limited to working with scalar arrays. Does this restriction still apply in 9i

RE: Long-running SQL

Robert, Thanks for your informative reply. Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

Oracle9i init.ora / Re: ORACLE-L Digest -- Volume 2002, Number 086

BOFH: you might want to check and see if your BIOS supports >512MB RAM and if you have any open slots, if so, assuming they aren't locked, you can steal some RAM from other people's computers in your office (they probably won't notice any difference, othrewise mumble something about how the

RE: Customize my SQLPlus login

Eric wrote: >-select 'RTFM' from dual; I can't quite get this to work in my version. What version are you using Maybe I need a patch. ;o) Dave -Original Message- Sent: Wednesday, March 27, 2002 1:19 PM To: Multiple recipients of list ORACLE-L (Oracle 7.3 Windows client) C

RE: Long-running SQL

Yep, Guy's book is among my fav's. I consider it an indispensable DBA book. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original

RE: Proper Case question

In the manual, my fine friend 1 select initcap(owner_first_name), owner_First_name 2 from vegas_mart 3* where rownum < 10 (INV-ELVIS)>/ INITCAP(OWNER_F OWNER_FIRST_NAM --- --- Barron Daniel BARRON DANIEL AlexALEX AlexALEX Thomas

RE: Long-running SQL - huh?

Um, You want to double check that last bit? Shouldn't it say, A _un_bounded range scan is caused by such actions like Where range_id > 100 Thom Dyson Director of Information Services Sybex, Inc. On 3/27/02 10:53:41 AM, "Freeman, Robert " <[EMAIL PROTECTED]> wrote: snip > > Well, depends on

Re:RE: Remote or Not? ... [VPN]

Eric, We're using an AT&T provided VPN service that works either through your DSL provider and/or AT&T WorldNet. IP works just dandy. It's damned easy to setup on the client too and the VPN server does all of that security/encryption stuff real sweetly. Just try logging in with the wrong p

Re: Customize my SQLPlus login

(Oracle 7.3 Windows client) C:\orawin95\PLUS33\GLOGIN.SQL -- -- SQL*Plus Global Login startup file. -- -- This is the global login file for SQL*Plus. -- Add any sqlplus commands here that are to be -- executed when a user invokes sqlplus -- Used by Trusted Oracle column ROWLABEL format A15

bulk collect in 9i

Hello, In 8i, the BULK COLLECT and FORALL commands are limited to working with scalar arrays. Does this restriction still apply in 9i? We are still on 8.1.6. In my case, I would like to do something like: TYPE tab_type IS TABLE OF oracle_table%ROWTYPE INDEX BY BINARY_INTEGER; plsql_table tab

RE: Long-running SQL

Thanks for clarifying, Mr. Cigarette Smoking Man. I loaned my book to someone (again). I find a lot of people could benefit from spending a week or so with that book. Whether or not they read it isn't my problem. Lisa > -Original Message- > From: Freeman, Robert [SMTP:[EMAIL PROTECT

RE: Remote or Not? ... [VPN]

We are currently "testing" Cisco VPN (Win2000 server with Oracle8i or 9i). Since so many people are getting broadband at home, I guess that if things go well with VPN for the the techies/admins, there might be additional demand for other users to get their exchange email natively (not OWA), m

RE: Long-running SQL

Cherie - So you are saying that some of the columns have null values? I'm not sure about that offhand. In any result, I found that partitioning could pay off, but the answers weren't always obvious and in the end I just had to test several alternatives. Somebody else on the list seemed to indicate

RE: Long-running SQL

<> Well, depends on the type of range scan. There are two kinds, bonded and unbounded. Bounded is indeed intelligent and starts and stops at specific points. This kind of range scan you will find, for example, when the WHEN clause contains something like: where range_id > 100 and range_id < 300

Re: odd explain plan

The optimizer doesn't seem to have recognised the query as a possible target for STAR or STAR TRANSFORMATION. It is quite possible that the data sizes are so small that the option is not even considered. One reason why Oracle might choose to do a cartesian join the first pair is if the optim

RE: Long-running SQL

Cherie, It is using the index. Range scans are not "smart" so to speak. In Harrison's sql tuning book, he states that a range scan is not intelligent. Like this: The index probe will start down the b-tree looking for account number. It will then continue the search for what it is looking for

hotbackup script for NT OR WIN2000

Hi Can some one send me hotback scripts for NT OR WIN'2000? With regards Seema _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re:RE: Oracle Wants Users to Hand over Apps Management

My question is how many companies will switch over to Oracle's desires and them have that middle of the night crash. When that happens what will Oracle do, have you fill out an eTAR on Metalink & we'll get back to you? Yeah right. My CIO's opinion, & we're not doing Oracle Apps but PeopleSoft,

Re: Archiving Data Strategies.

It depends on Application and hardware availability like disk space. It is mix and match situation. With 7.3.4 neither you have partioning option nor to export old data using query option from source table and delete rows from that table. If you are talking about Oracle Financials database , i

Proper Case question

Hi all:     Is there a function that allow me to proper case  data with in a column? 

RE: Long-running SQL

Dennis, When you partitioned the table, how did you determine what the limits on the partition should be? In this case, there are not always values for the other columns of the key so I'm not sure if we could partition on the full key. Cherie

RE: view current sql

Alternately following script can also be used to get sql text. JUst provide SPID To get text: select piece, sql_text from v$sqltext where (address,hash_value) in (select sql_address,sql_hash_value from v$session where paddr = (select addr from v$proc

RE: stop sharon

I like Ike!! ;o) -Original Message- Sent: Wednesday, March 27, 2002 7:43 AM To: Multiple recipients of list ORACLE-L Political propoganda is not welcome here. Don't do it again. Jared, list owner On Wednesday 27 March 2002 01:38, Arslan Bahar wrote: --

RE: Oracle Wants Users to Hand over Apps Management

I wonder what percentage of sites with ERP systems have not modified those systems to meet requirements not provided by the ERP suite as delivered? I wonder how many sites have modified the ERP system rather than change their business practices? In short what percentage of sites could take

spfile mystery on 9i

Hi! I have setup 9i as a 2 node RAC configuration on Tru64 5.1. The switch from normal init.ora to the new spfile configuration worked as documented. Then I tried to set global defaults for session_cached_cursors, which was a normal init.ora parameter in 8i: SQL> alter system set session_cache

RE: Long-running SQL

Cherie - This means that on the average the query is retrieving 366 values? I had something similar on our data warehouse. Indexed retrievals and full table scans took about the same amount of time. I ended up partitioning the table on that key and the queries flew. Interestingly enough, the weekl

Re: Convertion from Figures to Words

You should be able to work out what you want from this example. I think I got the basic logic from an old document on MetaBlink titled "Bul# 99802.782 DOLLARS INTO WORDS FOR CHECKS". (Gotta luv that old decode command) create table chk(num number); insert into chk values(1); insert into chk v

RE: Long-running SQL

Lisa, I'm not positive that it is actually using the index. This load ran last night so I was not able to trace as it happened. Following is the explain plan that Precise monitoring tool states that it should have used: Count (stopkey) Table access (by index rowid) EDM_DBO.EXP_COST_CENTER

RE: stop sharon

You have just received an FSF virus. You are on the honor system. Please remove all your files from your disk drives. > -Original Message- > From: Freeman, Robert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 27, 2002 10:24 AM > To: Multiple recipients of list ORACLE-L > Subject:

RE: Long-running SQL

Jerome, Yes, this data is not normalized. You are correct. I am not sure why the table was denormalized like this but it is not an option to change the underlying table at this point in time. The application is in the process of being redesigned but in the meantime, I have to keep the curren

Re: SQL using UTL_FILE

a) take a look at v$session_event to see where you are losing the time b) throw a trace on it and look for long running sql's Is it possible an analyze or equivalent has changed your access paths hth connor --- "Rusnak, George A." <[EMAIL PROTECTED]> wrote: > Group, > I have a stored procedure

RE: Long-running SQL

Cherie, Two things. 1. All the ORG_LEVEL_x_VALUE fields leads me to believe that the data isn't normalized. What happens when someone needs to add ORG_LEVEL_9_VALUE? 2. I think all the NVLs make your index worthless. About the only functions an index can work with are MIN and MAX. You might do

RE: SQL using UTL_FILE

Try and determine what it is doing/waiting for. Set up a 10046 trace at level 8. You may get lucky and see the problem within the first few minutes rather than wait the full 7 hours. Paul -Original Message- Sent: Wednesday, March 27, 2002 11:04 AM To: Multiple recipients of list ORACL

RE: Oracle Wants Users to Hand over Apps Management

-- "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Not to mention the nightmare of coordinating all the users into software > releases. > How about local customization and add-ons? > > Seriously, I initially thought that it was a good idea - I know some small > manufacturing companies locally who

RE: NUMBER of PROCESS

If you are on Unix, there are OS related parameters with semaphores that you might need to increase. Please provide detailed information such as the platform, the error messages that you got. Richard Ji -Original Message- Sent: Wednesday, March 27, 2002 10:18 AM To: Multiple recipients

RE: Long-running SQL

Cherie, At least the leading column in your index doesn't have an index-killing function on it in the Where clause - the NVL function on the other columns makes Oracle not use them for hitting the index. Since you're only interested in returning a single value, perhaps a stored function that ret

RE: Oracle Wants Users to Hand over Apps Management

Not to mention the nightmare of coordinating all the users into software releases. How about local customizations and add-ons? Seriously, I initially thought that it was a good idea - I knwo some small manufacturing companies locally who might truly benefit from this. But once the technical peop

RE: Make first character Versal

I didn't know what Versal meant so I found out. A versal letter is a letter that is enlarged to signify that it's the first letter of a passage. Think of illuminated scripts. Apparently the height of a versal letter is typically 24 times the width of the pen. So I think that we were all right to

Re: Convertion from Figures to Words

-- Ahmed Gholam Hussain <[EMAIL PROTECTED]> > Dear Listers , > > I need to convert Figures to Words ...EX : 123 to One Hundred Twenty > Three > Currently I am using a writen function to do that ..But it has > limitations ... > > Any suggestions regarding that ? There are moduled wh

SQL using UTL_FILE

Group, I have a stored procedure that runs from schema A on machine X, joins a table from another schema on machine X and a table from machine Y via a dblink and writes a file via UTL_FILE on machine X that is used in SQL Loader to insert data into a table for research. Pulls about 90 meg. For the

RE: stop sharon

My guess is that it's as likely a virus or Trojan as deliberate. My wife got it last weekend on AOL somehow. In about 10 minutes this thing managed to mail out over 1000 emails with the Trojan attached... AOL detected that something wasn't right and killed her session and locked out the account. W

RE: Long-running SQL

Hi Cherie, do you know for sure it is using the index? Have you traced it? Can you post the explain plan? What's the cardinality of account_number in this table? I can just hear those people over there screaming at you saying it's your problem... Lisa Koivu Oracle Database Administrator Fa

RE: How Could I identify the OS user name?

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

NUMBER of PROCESS

Hi, When I change the number of process, I mean increase it is there are any other paramter related to this one or not, becaz after i changed it try to open database and it couldn't open, so i put it back & open it. Any Idea Hamid Alavi Office 818 737-0526 Cell818 402-1987 The inform

RE: Oracle CPU Licensing

An analyst recently made a statement that under CPU licensing "Oracle is charging for unused CPU slots". I found this very surprising. I can see two possible interpretations: 1. If the system is capable of holding 8 CPUs, but I only have 4 CPUs installed, Oracle would charge me for 8 CPUs. I find

Re: Long-running SQL

Hi, What is the explain plan Jack Cherie_Machler@ge

Re: STATSPACK

Madhu, Did you try - 1. Diagnosing performance with Statspack - Oracle Magazine - March/April 2000 2. Performance tuning with statspack, Part II - Oracle Technical White Paper, July 2000 -Shaibal >From: "Reddy, Madhusudana" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple re

RE: Make first character Versal

Actually both return the same (just tried in 8.1.7 on NT): select substr (test_col, 0, 1) from my_table select substr (test_col, 1, 1) from my_table The problem may be with getting the VERSAL but don't know what it means Witold On 27 Mar 2002 at 4:38, Nicoll, Iain (Calanais) wrote: > Rolan

Re: Make first character Versal

Title: RE: Make first character Versal   "capital"/"uppercase" in Swedish   I am sorry but I don't know what you mean by VERSAL

RE: Oracle Wants Users to Hand over Apps Management

Sorry I can not agree! Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Wednesday, March 27, 2002 8:03 AM To: Multiple recipients of list ORACLE-L I think that we are all looking

RE: Oracle Wants Users to Hand over Apps Management

One big system = single point of failure. I had an eloquent answer to this, but I decided to delete it. ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, March 27, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Subject:

RE: Oracle Wants Users to Hand over Apps Management

I have thought about it. One product version. One OS. No continual patching. This describes MetaLink. Need I say more? Jay >>> [EMAIL PROTECTED] 03/27/02 08:03AM >>> I think that we are all looking at the article with clouded eyes, perhaps even teary eyed over the loss of financial stab

RE: Make first character Versal

Use NLS_INITCAP() fucntion like: 1* select nls_initcap('john smith') from dual SQL> / John Smith ;) -Message d'origine- De: Jan Pruner [mailto:[EMAIL PROTECTED]] Date: mercredi 27 mars 2002 13:23 À: Multiple recipients of list ORACLE-L

Long-running SQL

We have a statement that I feel takes too long to run in a nightly data load. The table it runs against has 386,000 records. It runs for about 10 seconds on average. We're only loading about 50,000 records a night but this statement is running during the majority of the 9-hour load time. Thi

RE: Convertion from Figures to Words

Look at http://www.dbasupport.com/forums/showthread.php?threadid=16103 Enter a value for what_number ?: 123456789123456 One Hundred Twenty Three Trillion Four Hundred Fifty Six Billion Seven Hundred Eighty Nine Million One Hundr

Jinitiator, SUN/Microsoft JVM security warnings

Since both Microsoft and Sun have issued joint warnings about vulnerabilities in the Windows version of JVM, would these apply to JInitiator as well? JInitiator is based on Sun's JVM, isn't it? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. e

RE: odd explain plan

Lisa, This is my explain plan: 1.19 SELECT STATEMENTSQL1 Cost = 19 2.1 SORT GROUP BY 3.1 HASH JOIN 4.1 TABLE ACCESS FULL OPERS_CNTR_CDE 4.2 HASH JOIN 5.1 TABLE ACCESS FULL FEE_TYP 5.2 HASH JOIN 6.1 MERGE JOIN CARTESIAN 7.1 TABLE ACCESS

Re: Long running SQL Problem?

Try something like select a.col1||a.col2, b.col3||b.col4 from table1 a, table2 b where a.col1||a.col2 = b.col3||b.col4 (+)) WHERE b.col3||b.col4 IS NULL; I think that works. Denha

Re: Make first character Versal

Your substring statement is wrong. It should be substr(1,1), not substr(0,1). HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 6:58 AM > Hallo, > > I know this question sound a bit simple, but can anyone giv

Re: stop sharon

Political propoganda is not welcome here. Don't do it again. Jared, list owner On Wednesday 27 March 2002 01:38, Arslan Bahar wrote: Content-Type: application/msword; charset="iso-8859-1"; name="filistin[1].doc" Content-Transfer-Encoding: 7bit Content

Re: Make first character Versal

Hi Second option can be done using INITCAP(namn) from test Jack Jan Pruner

RE: Make first character Versal

Roland, Substr starts with 1 eg select (substr (namn,1,1)) from test will give you the 1 character starting from the first character. Unfortunately I don't know what you mean by versal. Iain Nicoll -Original Message- Sent: Wednesday, March 27, 2002 11:59 AM To: Multiple recipients o

RE: Make first character Versal

Title: RE: Make first character Versal The following sql gives the first character of a column. I am sorry but I don't know what you mean by VERSAL select substr(version,1,1)  from database_control John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 27

Ang: Re: Make first character Versal

I found out what was wrong: wanted to do an update too... update test set test = upper(substr(namn,1,1)) || substr(namn,2) then my update worked Roland S Jan Pruner <[EMAIL PROTECTED]>@fatcity.com den 2002-03-27 04:23 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTE

  1   2   >