UTL_FILE question

files with monthly sets of data. This way data formonth1 is created as filename_012002.txt and so forth. Thanks much! Viktor Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

SQL Query Problem(possilble duplicate send, Sorry!)

4 ENGLAND 10 46Is 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 Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Re: SQL Query Problem(possilble duplicate send, Sorry!)

Thanks for your reply! Will try it now. Will this work in 8i? Viktor Bricklen Anderson [EMAIL PROTECTED] wrote: 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

RE: RE: Career Advice

I think so. Most of ourWebapps arewritten in Java, _javascript_, and Perl. Some minor web stuff is generated by PL/SQL. Viktor DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Viktor, Ryan - Is what you are experiencing the result of companies movingto open-systems Web-based architectures?Dennis

RE: RE: Career Advice

aining all the way.It's like thatall-in-one fax/printer/copier thing. And at the same time, the paycheck isn't as it had been either. Viktor [EMAIL PROTECTED] wrote: my biggest concern is the model for development has been changed. The model now is do most development with software engineers and have on

RE: RE: Career Advice

aining all the way.It's like thatall-in-one fax/printer/copier thing. And at the same time, the paycheck isn't as it had been either. Viktor [EMAIL PROTECTED] wrote: my biggest concern is the model for development has been changed. The model now is do most development with software engineers and

Re: Career Advice

time I am kinda excited about picking up on Java and Perl. The questions is what are the tricks and tips for learning on a fast track? Thanks! Viktor Stephane Faroult [EMAIL PROTECTED] wrote: Believe somebody who first learned SQL back in 83, it's too late forJava now. Run-of-the-mill skill. Any

RE: Career Advice

! Viktor DENNIS WILLIAMS [EMAIL PROTECTED] wrote: ViktorMy suggestion is to go for Perl as the quick win and impress your newboss. Perl also tends to be more useful for DBAs. Learning Java can be a more long-term proposition. First, you need tohave a strong understanding of object-oriented design

RE: SQL HELP - SOLVED!!!

Thanks to ALL for your help on this! As always your advice is greatly appreciated! Viktor"Jamadagni, Rajendra" [EMAIL PROTECTED] wrote: Try something like ... select id, col_1, col_2,sum(web_c),sum(other_c) from (select id, to_char(received_date,'-MM') col_1,yr||seq_no||ck co

SQL HELP!!!

Hello, I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do: for a given date range, i..e. start_date - end_date ('01/01/2003', '12/31/2003'), I need to count all "web", and "non-web" records. Ifseq_no 4000, then

Re: SQL HELP!!!

DCOPY from twhere received_date between '01/01/2003' and '12/31/2003'group by id,! p; to_char(received_date, '-mm'), sequence_no, id||yr||seq_no||ck ) group by received_date, msno, hardcopy / Viktor [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2003 01:59 PM Please respond t

Re: SQL HELP!!!

p; to_char(received_date, '-mm'), sequence_no, id||yr||seq_no||ck ) group by received_date, msno, hardcopy / Viktor <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/26/2003 01:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:

Re: SQL HELP!!!

te between '01/01/2003' and '12/31/2003'group by id, to_char(received_date, '-mm'), seq_no, id||yr||seq_no||ck)group by id, received_date Thanks again![EMAIL PROTECTED] wrote: Viktor, By using an inline view, count_web does indeed become a column. Did you try the query? Jared Viktor [EMAIL

Re: Fwd: RE: newbie dba question - another try

Thanks Darell! Your advice as well as from others is greatly appreciated. Darrell Landrum [EMAIL PROTECTED] wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be

Re: Fwd: RE: newbie dba question - another try

Thanks Darell! Your advice as well as from others is greatly appreciated. Darrell Landrum [EMAIL PROTECTED] wrote: Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be

Re: STATSPACK

Jared, You've got all the knowledge, for real! Is there a possibility of performance decrease when running statspack in Oracle 8.0.5? Thanks, Viktor [EMAIL PROTECTED] wrote: No, but you can run the 8.1.6 version.There's a couple of special scripts for doing so.http://www.oracle.com/oramag/oracle

OPEN CURSORS Question

Hello, I'm trying to find out what's causing this problemin one of the databases we have: Oracle 8.05/ Sun Solaris.Customers are using a front-end app where theyaccess databasevia Forms built modules and run a number of reports. The problem is that occasionally they get errors, each time slightly

RE: Orawomen

if a person lacks skills, she can be taught; as long as she is a nice person, they're fine with it. Regards, Viktor Rachel Carmichael [EMAIL PROTECTED] wrote: very technical, very detailed, and very dedicated. The fact that they were both attractive didn't hurt either. One majored in mathI'm

Oracle client for Mac OS X?

Folks, Can someone direct me to a source of good information on this topic. Is there wor will there be Oracle client for OS X? Any leads are very much apreciated! Thanks!Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Re: FW: developer 2000

I think you may need to get an upgraded installer version 3.3.1.1.0c. This is the one compatible with Y2K. Then, run the installer and select typical, and that should be it. Regards, Viktor Paulo Gomes [EMAIL PROTECTED] wrote: -Original Message- From: Paulo Gomes Sent: sexta-feira, 8

RE: FW: developer 2000

You need to get a patch.The one I was talking about isDev 2.1 Patch 6is patch. Look it up to metalink, or contact Oracle Support for assisstance. Paulo Gomes [EMAIL PROTECTED] wrote: THANKS Do u happen to know where can i get that? Regards Paulo -Original Message-From: Viktor [mailto

Displaying Foreign characters

Hello all, Is there a simple way to display correctlyforeign characters primarily found in name and address records? Currectly, NLS_LANGUAGE = AMERICAN in init.ora and NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 in the registry on client side. Problem is is that name and address records may have

Re:Spool Oracle Tables into Excel Format

By the way, would you use replace to get rid of the commas withiin fields so that Excel reads it properly? [EMAIL PROTECTED] wrote: Bob,You can create a CSV file from SQL*Plus with the following statement:select

SQL Question

table on FIRST_INIT, SECOND_INIT, INIT_SEQUENCE. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL

SQL Question (DISREGARD 1ST MESSAGE, SORRY)

, a.flag MEMBER_FLAG FROM names a, members m WHERE a.first_init = m.mem_first_init and a.second_init = m.mem_second_init and a.init_sequence = m.mem_init_sequence Thanks a lot in advance! Regards, Viktor __ Do You Yahoo!? Yahoo

Re: DECODE HELP SOLVED

will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET

DECODE HELP

! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: How to calculate time using SQL

Try this: select to_date('10:20:32','hh:mi:ss') - to_date('10:25:29', 'hh:mi:ss') from dual / Viktor --- Nguyen, David M [EMAIL PROTECTED] wrote: Is it possible to calculate seconds using SQL? For example, I'd like to subtract these two time to get difference in seconds: 10:20:32

[no subject]

://www.orafaq.com -- Author: Viktor 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

Weird Report Problem

so much! __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services

Re: LIKE and % operator

). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: Duplicate rows

Here is a query that was posted here a while ago: delete from pa_answer where rowid in (select rowid from p_answer pa where rowid (select min(pa2.rowid) from p_answer pa2 where pa.p_id = pa2.p_id and pa.p_name = pa2.p_name)) This should help. Viktor --- Alexander Ordonez [EMAIL PROTECTED

Re: How to calculate Last and First Day of Month?

Thanks to Jared and others for a quick assistance. Regards, Viktor --- [EMAIL PROTECTED] wrote: Well, yes the first day of the month is always 1. Representing it as the first day of the current month requires you to use the SYSDATE function. Returning the first day of the month can

Re: How to calculate Last and First Day of Month?

(like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services

ORA-01555: snapshot too old: rollback segment number...

-- Author: Viktor 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

RE: ORA-01555: snapshot too old: rollback segment number...

Viktor Regarding the rollback segments, I heard from Oracle that you need to allocate them with min extents=20. This will cause users to get their own extents and the chance that a new update will overwrite an old update that you need will decrease. Check metalink. they have

RE: The OCP bar is being raised

How many people outhere that you know do actually have OCM. Not ORACLE employees. Just curious... Regards, Viktor --- Bowes, Chris [EMAIL PROTECTED] wrote: Maybe I am completely misreading this. However, I didn't see the 8 to 9 OCP upgrade and that is why I said, you'll have to take them

Re: OCP discount is avaialable still?

Try Discount code S36 when you sign up for an exam. I used it before and it worked for me I did all my exam scheduling at www.prometric.com. Regards, Viktor --- Tirumala, Surendra [EMAIL PROTECTED] wrote: Hi List, I would like to know if anyone knows whether the OCP discount for otn

Re: WHERE CURRENT OF Question

). __ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network

RE: Stored procedure performance

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

RE: Happy Birthday List !!

). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services

Re: Report 2.5, how to bring up ' 0 ' when sql query returns null ?

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

SQL Question

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

RE: SQL Question

some_date_column BETWEEN :start_date and :end_date group by to_char(some_date_column, 'YYWW') -Original Message- From: Viktor [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Subject: SQL Question Hello all, Can

Re: Discount for register the exam

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

What do you think works faster?

We've got some dynamic sql proc. Attached are 2 files. Which one you think should work faster? Thanks. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Proc.sql The

Ascii code of tab?

What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED