Re: Linux profile - a little offtopic
hi, In linux it is bash shell and you have to change you bash_profile of oracle and not the .profile file. check that out Csillag Zsolt wrote: Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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 PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: Calculating The Median: Error Discovered in Oracle SQL 101 Code
Try this link: http://math.about.com/science/math/library/howto/htmean.htm Jared On Saturday 30 June 2001 19:00, MacGregor, Ian A. wrote: I ran the code from Oracle SQL 101 which Jared posted modifying it to find the median of the sal column on that table SQL select 2 rownum, 3 sal 4 from ( 5 select sal 6 from scott.emp 7 where sal is not null 8 union 9 select 1 from dual where 1=2 10 ) 11 group by sal, rownum 12 having rownum = ( 13 select decode( mod(total_freq,2), 141,trunc(total_freq/2 + 1), 150,trunc(total_freq/2) 16 ) 17 from ( 18select count(*) total_freq 19from scott.emp 20where sal is not null 21 ) 22 ) 23 and rownum = ( 24 select decode( mod(total_freq,2), 251,trunc(total_freq/2 + 1), 260,trunc(total_freq/2 + 1) 27 ) 28 from ( 29select count(*) total_freq 30from scott.emp 31where sal is not null 32 ) 33 ) 34 / values averaged ROWNUM in median -- -- 7 1600 8 2450 -- Median 2025 --- --- This answer is different from the result of the code I posted which uses the new analytical functions. select case when mod(number_salaried,2) = 0 then (select sum(sal)/2 from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = number_salaried/2 or salrank = number_salaried/2 +1) else (select sal from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = ceil(number_salaried/2)) end median from (select sal,rank() over (order by sal) as rk from scott.emp), (select count(sal) number_salaried from scott.emp) where rk = 1 / MEDIAN - 1550 --- - Emp is a 14 row table . The median should be the average of the seventh and eighth values. I cleared the computes and columns and ran the first part of the SQL 101 code clear computes utes cleared select rownum, sal from ( select sal from scott.emp where sal is not null union select 1 from dual where 1=2 ) group by sal, rownum / ROWNUMSAL -- -- 1800 2950 3 1100 4 1250 5 1300 6 1500 7 1600 8 2450 9 2850 10 2975 11 3000 ROWNUMSAL -- -- 12 5000 and also ran the part of my code which corresponded. I changed my code slightly so the salrank column would print. SQL select salrank, sal from(select sal, row_number() 2 over ( order by sal) as salrank 3 from scott.emp) 4 / SALRANKSAL -- -- 1800 2950 3 1100 4 1250 5 1250 6 1300 7 1500 8 1600 9 2450 10 2850 11 2975 SALRANKSAL -- -- 12 3000 13 3000 14 5000 14 rows selected. --- --- The reason for the different answers is now apparent. The SQL 101 code is tossing duplicate records. It's been a long time since my stats classes, but I'm about 99.99% confident you don't purge duplicates when computing a median. But even if I'm wrong about this, the SQL 101 code has reduced the set to 12 members, but it is still computing the median as if there were 14 members; that is, it is taking the average of the 7th and 8th values and not the average of the 6th and 7th. I hope there was a caveat in SQL 101 book stating the code only worked against columns with unique values, not including nulls. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Where is RemoteORADBA?
Anybody know the current web page or email address for Earl Shaffer and the company RemoteOraDba? Thx - Don
RE: Calculating The Median: Error Discovered in Oracle SQL 101 Co de
I was 99.99% that one doesn't toss duplicates when computing a median; thanks to the link Jared has posted, I'm now 100% confident. The Oracle SQL 101 code will correctly compute a median only if the values in the column it is applied against are unique, not including nulls. Median calculations are almost always performed against populations which have duplicate values. It's been stated before, All books have errors. Oracle SQL 101 should not be condemned to the trash for the error, but the mistake should enforce the rule that code posted here or written in a book by must be thoroughly tested before being employed. This rule especially includes the code I post. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Sunday, July 01, 2001 12:20 AM To: Multiple recipients of list ORACLE-L Code Try this link: http://math.about.com/science/math/library/howto/htmean.htm Jared On Saturday 30 June 2001 19:00, MacGregor, Ian A. wrote: I ran the code from Oracle SQL 101 which Jared posted modifying it to find the median of the sal column on that table SQL select 2 rownum, 3 sal 4 from ( 5 select sal 6 from scott.emp 7 where sal is not null 8 union 9 select 1 from dual where 1=2 10 ) 11 group by sal, rownum 12 having rownum = ( 13 select decode( mod(total_freq,2), 141,trunc(total_freq/2 + 1), 150,trunc(total_freq/2) 16 ) 17 from ( 18select count(*) total_freq 19from scott.emp 20where sal is not null 21 ) 22 ) 23 and rownum = ( 24 select decode( mod(total_freq,2), 251,trunc(total_freq/2 + 1), 260,trunc(total_freq/2 + 1) 27 ) 28 from ( 29select count(*) total_freq 30from scott.emp 31where sal is not null 32 ) 33 ) 34 / values averaged ROWNUM in median -- -- 7 1600 8 2450 -- Median 2025 --- --- This answer is different from the result of the code I posted which uses the new analytical functions. select case when mod(number_salaried,2) = 0 then (select sum(sal)/2 from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = number_salaried/2 or salrank = number_salaried/2 +1) else (select sal from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = ceil(number_salaried/2)) end median from (select sal,rank() over (order by sal) as rk from scott.emp), (select count(sal) number_salaried from scott.emp) where rk = 1 / MEDIAN - 1550 --- - Emp is a 14 row table . The median should be the average of the seventh and eighth values. I cleared the computes and columns and ran the first part of the SQL 101 code clear computes utes cleared select rownum, sal from ( select sal from scott.emp where sal is not null union select 1 from dual where 1=2 ) group by sal, rownum / ROWNUMSAL -- -- 1800 2950 3 1100 4 1250 5 1300 6 1500 7 1600 8 2450 9 2850 10 2975 11 3000 ROWNUMSAL -- -- 12 5000 and also ran the part of my code which corresponded. I changed my code slightly so the salrank column would print. SQL select salrank, sal from(select sal, row_number() 2 over ( order by sal) as salrank 3 from scott.emp) 4 / SALRANKSAL -- -- 1800 2950 3 1100 4 1250 5 1250 6 1300 7 1500 8 1600 9 2450 10 2850 11 2975 SALRANKSAL -- -- 12 3000 13 3000 14 5000 14 rows selected. --- --- The reason for the different answers is now apparent. The SQL 101 code is tossing duplicate records. It's been a long time since my stats classes, but I'm about 99.99% confident you don't purge duplicates when computing a median. But even if I'm wrong about this, the SQL 101 code has reduced the set to 12 members, but it is still computing the median as if there were 14 members; that is, it is taking the average of the 7th and 8th values and not the average of the 6th and 7th. I hope there was a caveat in SQL 101 book
RE: Linux profile - a little offtopic
Also, make sure the .profile is executable. It isn't by default usually. Also make sure the oracle account is setup to use a shell that the .profile actually applies to. For example, ksh (my personal favoriate). C shell uses the .login. -Original Message- Sent: Saturday, June 30, 2001 10:20 AM To: Multiple recipients of list ORACLE-L On June 30, 2001 01:30 pm, Csillag Zsolt wrote: Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. Take a look at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: ALTER SYNONYM?
Rick: No. There is no alter synonym command in SQL (none that I can find or know of, at least). The way you describe is the only way to do it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 30, 2001 4:56 PM Is there a way to do what would be an ALTER SYNONYM? I've got a synonym created that rotates between pointing to two different tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is so that behind the scenes, I can truncate and reload TABLE_A, and then swap, etc. so the table never disappears.) However, when I want to switch the SYNONYM from pointing to TABLE_A to pointing to TABLE_B, the only way is to: drop synonym table_syn; create synonym table_syn for table_b; Is there a way to make that instantaneous for the database? If someone does a select at the exact instant between those two commands, it'll error out, because the table won't exist. -Rick +--+ | Rick Osterberg [EMAIL PROTECTED] | | Database Applications Specialist FAS Computer Services | +--+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rick Osterberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
RE: Calculating The Median: Error Discovered in Oracle SQL 101 Co de
Ian, Okay, I'm curious, I did a search on amazon and found Oracle PL/SQL 101 and Oracle SQL: 101 Frequently Asked Questions. Which of these (or is it a different one?) are you talking about here? The reason I ask is, I have done tech-edit (which includes code testing) for Oracle Press, although not on the PL/SQL book. And when I have done technical edits, I have insisted on either removing the incorrect code or replacing it with working code. If the Oracle Press book was not edited well, a) I'm surprised but b) I will get in touch with them to have them review it again for the next edition. Rachel From: MacGregor, Ian A. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Calculating The Median: Error Discovered in Oracle SQL 101 Co de Date: Sun, 01 Jul 2001 08:50:23 -0800 I was 99.99% that one doesn't toss duplicates when computing a median; thanks to the link Jared has posted, I'm now 100% confident. The Oracle SQL 101 code will correctly compute a median only if the values in the column it is applied against are unique, not including nulls. Median calculations are almost always performed against populations which have duplicate values. It's been stated before, All books have errors. Oracle SQL 101 should not be condemned to the trash for the error, but the mistake should enforce the rule that code posted here or written in a book by must be thoroughly tested before being employed. This rule especially includes the code I post. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Sunday, July 01, 2001 12:20 AM To: Multiple recipients of list ORACLE-L Code Try this link: http://math.about.com/science/math/library/howto/htmean.htm Jared On Saturday 30 June 2001 19:00, MacGregor, Ian A. wrote: I ran the code from Oracle SQL 101 which Jared posted modifying it to find the median of the sal column on that table SQL select 2 rownum, 3 sal 4 from ( 5 select sal 6 from scott.emp 7 where sal is not null 8 union 9 select 1 from dual where 1=2 10 ) 11 group by sal, rownum 12 having rownum = ( 13 select decode( mod(total_freq,2), 141,trunc(total_freq/2 + 1), 150,trunc(total_freq/2) 16 ) 17 from ( 18select count(*) total_freq 19from scott.emp 20where sal is not null 21 ) 22 ) 23 and rownum = ( 24 select decode( mod(total_freq,2), 251,trunc(total_freq/2 + 1), 260,trunc(total_freq/2 + 1) 27 ) 28 from ( 29select count(*) total_freq 30from scott.emp 31where sal is not null 32 ) 33 ) 34 / values averaged ROWNUM in median -- -- 7 1600 8 2450 -- Median 2025 --- --- This answer is different from the result of the code I posted which uses the new analytical functions. select case when mod(number_salaried,2) = 0 then (select sum(sal)/2 from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = number_salaried/2 or salrank = number_salaried/2 +1) else (select sal from(select sal, row_number() over ( order by sal) as salrank from scott.emp) where salrank = ceil(number_salaried/2)) end median from (select sal,rank() over (order by sal) as rk from scott.emp), (select count(sal) number_salaried from scott.emp) where rk = 1 / MEDIAN - 1550 --- - Emp is a 14 row table . The median should be the average of the seventh and eighth values. I cleared the computes and columns and ran the first part of the SQL 101 code clear computes utes cleared select rownum, sal from ( select sal from scott.emp where sal is not null union select 1 from dual where 1=2 ) group by sal, rownum / ROWNUMSAL -- -- 1800 2950 3 1100 4 1250 5 1300 6 1500 7 1600 8 2450 9 2850 10 2975 11 3000 ROWNUMSAL -- -- 12 5000 and also ran the part of my code which corresponded. I changed my code slightly so the salrank column would print. SQL select salrank, sal from(select sal, row_number() 2 over ( order by sal) as salrank 3 from scott.emp) 4 / SALRANKSAL -- -- 1800 2
Exploding the Myths paper
Okay, I've been told that the paper and slides for my presentation Exploding the Myths is now up on the NYOUG site www.nyoug.org Rachel _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
RE: Odd Access/ColdFusion/SQLPluss access problem
I do have this problem last few year , when my System administrator told me that ,it might be becoz of the table itself ? How much row/field in that particular tables ? -Original Message- Sent: Saturday, June 30, 2001 6:57 AM To: Multiple recipients of list ORACLE-L Hi. A developer called me recently complaining that he can't access a table. When he tries select * he gets a few rows back (no more than 6) and the rest of them are filled with #NAME?. He tried accessing this table via MS Access, Cold Fusion and SQLPlus with the same result. I have logged to the server and confirmed that the table is there and the data are OK (at least look OK). I have dropped the table and recreated it. After that he was able to see about 100 rows (out of 976). I am very tempted to say that this is a network pronblem, but he is only having problems accessing this one table. That may mean some kind of corruption, but I can see it fine. Does anyone have any idea how should I approach this issue. We are running 817 on RS/6000 thank you gene = __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
test - pl. delete
test Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: Calculating The Median: Error Discovered in Oracle SQL 101 Co de
On Sunday 01 July 2001 09:50, MacGregor, Ian A. wrote: It's been stated before, All books have errors. Oracle SQL 101 should not be condemned to the trash for the error, but the mistake should enforce the rule that code posted here or written in a book by must be thoroughly tested before being employed. This rule especially includes the code I post. Yes, Oracle SQL 101 is a very good book, I've made use of the techniques in it a number of times. It's a rare tech book with no mistakes. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Re: Linux profile - a little offtopic
Kimberly, Since .profile is of little use unless sourced, why make it executable? Maybe I missed something here, but I've never used an executable .profile. Jared On Sunday 01 July 2001 11:15, Kimberly Smith wrote: Also, make sure the .profile is executable. It isn't by default usually. Also make sure the oracle account is setup to use a shell that the .profile actually applies to. For example, ksh (my personal favoriate). C shell uses the .login. -Original Message- Sent: Saturday, June 30, 2001 10:20 AM To: Multiple recipients of list ORACLE-L On June 30, 2001 01:30 pm, Csillag Zsolt wrote: Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. Take a look at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).
Cost of Porting Oracle to a different Unix !!!
Hi, In my Company Oracle8i running in Dec Alphaserver2001 on Compaq Tru Unix. Recently it was decided to buy another Server(may be IBM or Sun) and to Port Oracle Server to this New Server. Of course! We are going to discard the Alphaserver2001 and use it for other purpose. Now, the question is what is the recent Oracle pricing policy to Port Oracle8i from one Unix to Another ? Is the Cost is same as buying new Oracle8i for New OS ? Any help on this will be most welcome or any referenece to Web page in this regard is welcome and appreciated. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: N J Neog INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 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).