On May 15, 2:07 pm, neilberry wrote:
> I'm trying to figure out how to generate a Jenks natural break
> distribution of set of values with pl/sql. Don't even know where to
> start. Any ideas?
> Thanks
> Neil
Can we assume that you do know the algorithm?
(not being a smartass... it is not a triv
I'm trying to figure out how to generate a Jenks natural break
distribution of set of values with pl/sql. Don't even know where to
start. Any ideas?
Thanks
Neil
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google
Groups "Oracle
Interesting... thanks for looking into this... I only have a 10g version of
Oracle, but one of our QA'ers is having problems running the script... maybe
it's an issue with her install.
Thanks again,
Dave
On Fri, May 15, 2009 at 11:01 AM, ddf wrote:
>
>
>
> On May 15, 9:36 am, David Hart wrote:
This one works:
drop table driver;
drop table temp_1;
create table driver
as
select level id
from dual
connect by level <=100;
create table temp_1 as select * from driver where 1=0;
declare
type idTyp is table of driver%rowtype
index by binary_integer;
ids idTyp;
cursor c is selec
On May 15, 9:36 am, David Hart wrote:
> Thanks for the reply :)
> Sorry for the confusion the DBMS_UTILTIY.COMPILE_SCHEMA call is wrapped in a
> BEGIN / END Block. Here's the full script:
>
> DECLARE
>
> v_sql VARCHAR2(32000);
>
> createstmt VARCHAR2(500);
>
> target VARCHAR2(50);
>
> BEGIN
>
>
Thanks for the reply :)
Sorry for the confusion the DBMS_UTILTIY.COMPILE_SCHEMA call is wrapped in a
BEGIN / END Block. Here's the full script:
DECLARE
v_sql VARCHAR2(32000);
createstmt VARCHAR2(500);
target VARCHAR2(50);
BEGIN
--COMPILE ALL OBJECTS
DBMS_UTILITY.COMPILE_SCHEMA(USER);
--REC
On May 14, 11:31 am, Dave Hart wrote:
> Hi,
> I have a script that has to run in 9i and 10g. At the end of the
> script the DBMS_UTILITY.COMPILE_SCHEMA procedure gets called to
> recompile the schema.
>
> This works in 10g but not in 9i:
> DBMS_UTILITY.COMPILE_SCHEMA(USER);
>
> In 9i I have to
On May 14, 9:51 pm, denis wrote:
> Recently came across Steven Feuerstein's
> article:http://www.oracle.com/technology/oramag/oracle/08-mar/o28plsql.html.
> After reading it, I realized that the simple fact is when using limit
> clause in the bulk collect, if one sets limint to be n, and if Or
