Re: Renumber a set of grupped rows?

4 30 5 30 6 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Renumber a set of grupped rows?

001 10004 002 10004 003 10004 004 10004 005 10004 006 etc Any ideas? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Renumber a set of grupped rows?

4 305 306 Maryann Atkinson wrote: I have a 1-rows table with 2 columns, Emp_ID and Req_ID. There are about 150 different emp_ids

RE: Renumber a set of grupped rows?

002 10004 003 10004 004 10004 005 10004 006 etc Any ideas? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

var source_data varchar2(12)

I'm looking at a PL/SQL script that goes like this -- Header var Source_Data VARCHAR2(12) DECLARE Num1 NUMBER; BEGIN Source_Data := '1';

var source_data varchar2(12)

of the Declare section? Is it used for bind-variables, is that what it is? thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Mladen Re: var source_data

. And you feel free to answer them the way you've answered the ones you did a better job on. :-) maa On 11/11/2003 04:44:24 PM, Maryann Atkinson wrote: My original posting had a few lines truncated, so here I go again: I'm looking at a PL/SQL script that goes like this -- Header var Source_Data

Re: var source_data varchar2(12)

: Maryann Atkinson 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

Re: PCTFREE and PCTUSED

been because there werent many people on the system at the time. thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Why does script have more than one slash(/) inside?

Sorry if I bore you all with my dumb questions, its just that the simplest and silliest things appear complex, if we dont know them... Often when I learn something, I go : was that all? and they go, yes, yes, that was all... Well, let me show you what I mean.. What does it mean when a .sql

Re: PCTFREE and PCTUSED

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

PCTFREE and PCTUSED

with just one parm, that being PCTFREE. But Oracle wouldnt have just put a parm there without any usage, so I guess there's something I dont see... Any ideas/examples? Any good reasoning anywhere? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson

Re: PCTFREE and PCTUSED

ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: PCTFREE and PCTUSED

, then would have to move it off the free list, therefore NOT doing work for me but itself, etc... right? So, PCTFREE and PCTUSED are kind of like boundary values, or kind-of-like FREE SPACE IS BETWEEN PCTUSED and PCTFREE values, right? Many, many thanks! maa On 2003.11.04 18:09, Maryann Atkinson

Re: PCTFREE and PCTUSED

-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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

Re: insert and commit 1000 records at a time

finished. Jared MaryAnn Atkinson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 01:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: insert and commit 1000 records

Re: insert and commit 1000 records at a time

if insert_count = 1000 then commit and reset counter to zero insert_count :=0; 4. At the end when no rows found, and insert_count 0 then commit. I think you get the idea - Kirti MaryAnn Atkinson wrote: I still dont get it... I dont know what I have done to have me confused more than I

For Melanie Caffrey

-Original Message- MaryAnn Atkinson Sent: Friday, October 17, 2003 2:43 PM To: Multiple recipients of list ORACLE-L I still dont get it... I dont know what I have done to have me confused more than I first asked the question... --- [EMAIL PROTECTED] wrote: My bad. The SQL is not quite right

RE: sometimes pressure seems to get the best of us.

. Peace, Melanie -Original Message- Maryann Atkinson Sent: Friday, October 17, 2003 5:04 PM To: Multiple recipients of list ORACLE-L For Melanie Caffrey, Woww... Was your interference RUDE or what? Several people have offered you very clear and very good suggestions

insert and commit 1000 records at a time

primary key violation... thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: insert and commit 1000 records at a time

--- [EMAIL PROTECTED] wrote: That will work, slowly. You might like to try something like this insert into resource nologging select * from rqmt append; How's that commiting every 1000 records? Read up on the 'append' and 'nologging' first. ??? Maryann Atkinson

info on SQL Loader?

position(8:8)char , DESCRIPTION position(9:28) char , EXPIRED_IND constant N ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services

comments on EXECUTE IMMEDIATE

ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

comments on 8i's autonomous PL/SQL block?

://www.orafaq.net -- Author: Maryann Atkinson 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

RE: comments on EXECUTE IMMEDIATE

://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

full usefullness of CURRENT OF ???

: http://www.orafaq.net -- Author: Maryann Atkinson 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

RE: full usefullness of CURRENT OF ???

only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: full usefullness of CURRENT OF ???

FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson 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

full usefullness of CURRENT OF ???

: http://www.orafaq.net -- Author: Maryann Atkinson 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

ROWNUM is driving me nuts - queries suggested produced no results

$29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ROWNUM -- HOW ARE ROWS SELECTED?

: http://www.orafaq.net -- Author: MaryAnn Atkinson 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

RE: ROWNUM - THATS THE ONE!!! THAT DID IT!!!

taught Comp Engr at UMC... Many thanks, maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network

RE: ROWNUM's peculiarities...

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ROWNUM - Can the inner-outer idea be extended to an update?

in between. Thanks, maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Commit 1000 at a time, thats what I ended up doing

SET GENDER = 'F' WHERE GENDER = ' ' AND ROWNUM = 100; __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat

update about 100K records

of 1000 per time? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: update about 100K records

, and at the 1000th record when it reaches the commit, its dropping out of the loop. Can I use ROWNUM to update them in batches of 1000 per time? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED

Re: update about 100K records

? MaryAnn Atkinson [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Re: update about 100K records

. Can I use ROWNUM to update them in batches of 1000 per time? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: update about 100K records

? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

something appears to be funny with ROWNUM

ideas? thx maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

which util do I use to see oracle's execution plan?

actually try it and see results? b. If I need to tune the SGA ONLY, should I concentrate on the log buffers, the library cache or the shared pool? thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: [EMAIL PROTECTED] Fat City Network Services

where is info stored when using the ANALYZE cmd?

: Maryann Atkinson 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