Re: winders email client.
[EMAIL PROTECTED] wrote: Where can you get this firebird browser? http://mozilla.org/ -- Bricklen Anderson PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: MS Access
viraj2 wrote: Hi all, I was wondering if any one out here knows if there is a good list (mailing list) for discussing MS Access problems. I am specifically looking for migrating/converting large Access database into Oracle database. I need to know what will be the steps to convert such a database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja Oracle has a product called Migration Workbench that converts various other db's to Oracle. Can't vouch for it performance, never having used it before though. http://otn.oracle.com/tech/migration/workbench/index.html http://www.oracle.com/oramag/oracle/02-may/index.html?o32tools.html -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: how to hide oracle password from a unix ps -ef | grep?
Ryan wrote: Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? Try http://asktom.oracle.com/pls/ask/f?p=4950:8:12188015396454707431::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:142212348066, -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SQL Query Problem(possilble duplicate send, Sorry!)
Viktor wrote: Thanks for your reply! Will try it now. Will this work in 8i? Viktor If it works at all, then it should work in both 8i and 9i, although I don't have a version of 8i handy right now to try this on. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SQL Query Problem(possilble duplicate send, Sorry!)
Viktor wrote:
Hello all,
I am working with a query that does some counts. I've hit a brick wall
and can't get passed trying to figure out how I can make the query show
percentages %.
Here is the query:
select "COUNTRY",
count ("MSS") "COUNT_MSS"
FROM (
SELECT DISTINCT
ms.journal_id||ms.yr_of_issue||ms.ms_sequence_no||ms.check_char MSS,
m.RVIEWNUM_INIT_INITSET||M.RVIEWNUM_INIT_SITE||M.RVIEWNUM_INITSEQ
"NAME_ID",
NVL(a.country,'USA') "COUNTRY"
FROM mscript ms, reviewms m, address a, journal j
WHERE (m.first_return between '01/01/2003' and '12/31/2003'
or m.second_return between '01/01/2003 and '12/31/2003'
or m.second_return between '01/01/2003 and '12/31/2003')
and ms.journal_id = j.journal_id
and M.MSNUMBER_JCO! DE = ms.journal_id
and M.MSNUMBER_YRISSUE = ms.yr_of_issue
and M.MSNUMBER_MS_SEQNO = ms.ms_sequence_no
and M.MSNUMBER_CKCHAR = ms.check_char
and m.RVIEWNUM_INIT_INITSET = a.namekey_init_initset(+)
and M.RVIEWNUM_INIT_SITE = a.namekey_init_site(+)
and M.RVIEWNUM_INITSEQ = a.namekey_initseq(+)
and a.addtype_addrstyp in ('m', 'p')
and a.addtype_typeno = 1
and (a.addr_end_date is null
or a.addr_end_date > sysdate)
and (first_recommend not in
('1','2','3','4','5','6','7','8','9','F','P','N','S','u')
or second_recommend not in
('1','2','3','4','5','6','7','8','9','F','P','N','S','u'))
order by 1)
GROUP BY ROLLUP(COUNTRY)
And the output:
COUNTRYCOUNT_MSS
AUSTRALIA 1
AUSTRIA 2
BELGIUM 4
CANADA 20
CHILE 1
CHINA 3
CZECH REPUBLIC1
DENMARK 4
ENGLAND 10
46
Is there a way I can also display a percentage column, that is the
percentage of the total in the same SQL statement?
As always thanks so much!
Viktor
Will this work? (ran a simple test case that worked, although this may not):
select
country,count_mss,round((count_mss/decode(overall_total,0,1,overall_total))*100)||'%'
pct
from (
select "COUNTRY",
count ("MSS") over (partition by "MSS") "COUNT_MSS",
count("MSS") over () overall_total
FROM (
SELECT DISTINCT
ms.journal_id||ms.yr_of_issue||ms.ms_sequence_no||ms.check_char MSS,
m.RVIEWNUM_INIT_INITSET||M.RVIEWNUM_INIT_SITE||M.RVIEWNUM_INITSEQ
"NAME_ID",
NVL(a.country,'USA') "COUNTRY"
FROM mscript ms, reviewms m, address a, journal j
WHERE (m.first_return between '01/01/2003' and '12/31/2003'
or m.second_return between '01/01/2003 and '12/31/2003'
or m.second_return between '01/01/2003 and '12/31/2003')
and ms.journal_id = j.journal_id
and M.MSNUMBER_JCO! DE = ms.journal_id
and M.MSNUMBER_YRISSUE = ms.yr_of_issue
and M.MSNUMBER_MS_SEQNO = ms.ms_sequence_no
and M.MSNUMBER_CKCHAR = ms.check_char
and m.RVIEWNUM_INIT_INITSET = a.namekey_init_initset(+)
and M.RVIEWNUM_INIT_SITE = a.namekey_init_site(+)
and M.RVIEWNUM_INITSEQ = a.namekey_initseq(+)
and a.addtype_addrstyp in ('m', 'p')
and a.addtype_typeno = 1
and (a.addr_end_date is null
or a.addr_end_date > sysdate)
and (first_recommend not in
('1','2','3','4','5','6','7','8','9','F','P','N','S','u')
or second_recommend not in
('1','2','3','4','5','6','7','8','9','F','P','N','S','u'))
order by 1)
GROUP BY ROLLUP(COUNTRY))
(not sure how it will react to a 'group by rollup..' though.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bricklen Anderson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: OFA document
Pete Finnigan wrote: Hi everyone I need to reference the "official" OFA document in a training course I am writing and google and otn / metalink have not turned it up for me yet. Does anyone know a URL for this paper? Thanks in advance Kind regards Pete here's an older version: http://otn.oracle.co.kr/docs/oracle78/ibm/server.803/A54988/ch1_ofa.htm didn't Cary Milsap develop the OFA? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OFA document
Pete Finnigan wrote: Hi everyone I need to reference the "official" OFA document in a training course I am writing and google and otn / metalink have not turned it up for me yet. Does anyone know a URL for this paper? Thanks in advance Kind regards Pete and here's a newer one: http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95490/orahome.htm#1004903 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sqlplus and HTML
Browett, Darren wrote:
Happy new year to all !.
I am trying to create some html reports using set markup html, and have
one question,
when doing a select col1,col2 … from some_table, I would like the field
names to be a
different colour/shade.
Is that possible doing style sheets. I did find some doc's that showed
the fields names being
shaded, but they didn't show how to do it.
Any code or links would be appreciated.
Thanks
Edit the following:
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD 'page title -
-
BODY {background: white} -
TH {background: green} -
TD {background: yellow} -
' -
BODY 'TEXT="black"' -
TABLE 'WIDTH="95%" BORDER="2"'
add the usual css attributes as needed etc
hth
--
Bricklen Anderson, Database Administrator
PresiNET Systems
http://www.PresiNET.com
Live Demo: https://www.presinet.com/secure/login
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bricklen Anderson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: what is business intelligence?
[EMAIL PROTECTED] wrote: I see this alot when people look for data warehouse people. any idea what is meant by this? Not look for the obvious oxymoronic joke. This was briefly covered several days ago in c.d.o.misc (watch for wrap) http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=br4fa8%24dtc%241%40hercules.btinternet.com&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DISO-8859-1%26q%3Dwhat%2Bis%2Bbi%26btnG%3DGoogle%2BSearch%26meta%3Dgroup%253Dcomp.databases.oracle.* -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Fedora (pink hat)
eric king wrote: Again what is FedOra? Too lazy to run google at this time... http://fedora.redhat.com/ http://www.linuxjournal.com/article.php?sid=7257 -- Bricklen Anderson PresiNET Systems http://www.PresiNET.com Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Could not run export utility from cron job
Simpson, Ken wrote: I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken How about adding the line: source /.(bash_)profile to the shell script that runs exp? Unfortunately, I'm not in a position to test this where I am right this minute. -- PresiNET Systems http://www.PresiNET.com Online Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
