in the
outstanding_vested_for_100k function.
Why is the motivating SQL shown in the trace first?
Is the rule for determining recursive relationships in a case like
this simply to follow the increasing dep values (with detours for
true recursive SQL, such as data dictionary access, that follows
Cary's rule
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Mladen Gogala
Sent: Thursday, October 23, 2003 10:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
B*tree indexes
in an analytic function?
B*tree indexes are ALWAY ordered. That's the way they're created and searched.
I don't know the difference between full index scan and fast full index scan.
I know that the latter is used when the tble rows are not needed. Sounds like
both methods are reading all leaf
blocks. Rows are returned as they've read from blocks, thus
no order can be guaranteed.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 8:39 AM
function?
Mladen
Mladen Gogala wrote:
B*tree indexes are ALWAY ordered
www.hotsos.com for schedule details...
-Original Message-
Mladen Gogala
Sent: Thursday, October 23, 2003 10:34 PM
To: Multiple recipients of list ORACLE-L
function?
B*tree indexes are ALWAY ordered. That's the way they're created and
searched.
I don't know the difference between full index scan
over an index fast full scan in an analytic function?
The FF index scan reads all the block in the index, using multiblock
reads. The kernel then discards the branch blocks. If sorting of the
result set is required, then this is a separate row source operation,
because the rows don't come out
, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L
analytic function?
you worked for oracle for 10 years and you have to guess? how secret do
they keep these internals documents on the algorithms?
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/10/24 Fri PM 01:19:25 EDT
To: Multiple
Tanel
Tanel Poder wrote:
As an addition to Vladimir's response:
I cannot provide you with detailed information -- can only give pointers
to the documentation -- otherwise it would look suspicious :)
Full scan will search from index root block using branch blocks to first
leaf block. And since all
Vladimir Begun wrote:
Tanel Poder wrote:
FFS will scan from index header block (note that index segment header and
index root block are different ones) up to segment high water mark using
multiblock reads and ignoring contents of root, branch, bitmap, extent
map,
freelist group blocks. Rows are
I have an index on the two columns used in this query. Why would the optimizer choose
an index full scan over an index fast full scan?
My question isnt why an index is used, but the type of index scan?
select *
from (select col1, col2,
dense_rank()
over (partition by
[EMAIL PROTECTED]
Subject: index full scan over an index fast full scan in an analytic function?
I have an index on the two columns used in this query. Why would the optimizer
choose an index full scan over an index fast full scan?
My question isnt why an index is used, but the type
of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
i cant attach the 10053 trace. it has proprietary info. There
isnt much in analytic explain plan either.
does anyone know in general why a full scan would be faster than
a fast full scan
why would you not need a sort with a full index scan and need one with a
fast full scan?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 5:19 PM
function?
Possibly to avoid a sort operation (assuming that you might be able
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Ryan
Sent: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
why would you not need a sort with a full index scan and need one with a
fast
: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
why would you not need a sort with a full index scan and need one with a
fast full scan?
- Original Message -
To: Multiple
.
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Ryan
Sent: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an
analytic
function?
why
Vladimir Begun wrote:
Full scan
This is available if a predicate references one of the columns in the
index. The predicate does not need to be an index driver. Full scan
is also available when there is no predicate, if all of the columns
in the table referenced in the query are included in the
Hi all,
I have a table like this, both cols are Nullable.
SQL desc test
Name Type
- -
STATUSCHAR(1) (could be A or D)
IDNUMBER
I'd like to build a unique index on column ID when the
status='A', how to create this function
Here's a link from AskTom that goes into good detail on what you want to
accomplish. He also demonstrates how to use concatenated function based
indexes which I think what you're looking for. Even though his example is
based upon NULLS you can easily modify his code to work for you.
http
SQL select PERCENTILE_CONT(0.5)
2within group (ORDER BY sal DESC) sal
3 from emp;
SAL
--
1550
hth
connor
--- Ben [EMAIL PROTECTED] wrote: median
functionhere is a note from the list from
awhile aback:
Since this subject was brought back up, I thought
maybe
ORACLE-L
Subject: RE: median function
SQL select PERCENTILE_CONT(0.5)
2within group (ORDER BY sal DESC) sal
3 from emp;
SAL
--
1550
hth
connor
--- Ben [EMAIL PROTECTED] wrote: median
functionhere is a note from the list from
awhile aback:
Since
Title: median function
I'm attempting to write a query to calculate the median
of a column of numbers.
The first solution I came across was
Select avg(col1) MEDIAN from
( select rownum row1, col1 from a where col1 in (select col1 from a )) a
where a.row1 in ( select floor(count(*)/2 +.5
Title: median function
here
is a note from the list fromawhile aback:
Since
this subject was brought back up, I thought maybe some would be interested
in the following. I've never had a need to calculate a median, but, I knew
Celko's SQL for Smarties had a few variations and examples from
hi all,
this is purushottam hegde from Bangalore(IND)
i am relatively new to oracle and so to this group.
iam having a problem with function...
it goes like this.
SQL CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2) return varchar2 is 2 resex varchar2(3); 3 Begin 4 SELECT sex into resex
function cannot be called with EXEC. u have to call it within a
procedure...
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of purushottam krishna
hegdeSent: Friday, June 06, 2003 5:05 PMTo: Multiple
recipients of list ORACLE-LSubject
Hi
purushotam,
since
it is a function that you are creating , its return value needs to be
collected.
hence
after BEGIN clause give a statement like
v_ret:=EMP_SEL('gali'); where v_ret
is a local variable of type varchar2
Thiswill work.
Regards
Kesh
-Original Message-From
The error message tells you all: EMP_SEL is not a procedure, it's a function.
You cannot execute functions like that. Functions are called and not executed.
try something like
declare
ret varchar2(3);
begin
ret:=emp_sel('gali');
dbms_output.put_line('RET:'||ret);
end;
/
On 2003.06.06 07:35
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Cc:
hi all,
this is purushottam hegde from Bangalore(IND)
i am relatively new to oracle and so to this group.
iam having a problem with function...
it goes like this.
SQL CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2
exec only works with procedures. you can execute a function by calling to from sql as
such
select emp_sel('gali')
from dual;
or with a pl/sql block
declare
resex varchar2(3);
begin
resex := emp_sel('gali');
end;
From: purushottam krishna hegde [EMAIL PROTECTED]
Date: 2003/06/06 Fri AM
you
need to accept the return value of the function in a variable. the correct way
to do is
SQL var a varchar2(1000)
sql execute :a := emp_sel('gali')
SQL print a
OR
SQLdeclare
SQLa varchar2(1000);
SQLbegin
SQLa := emp_sel('gali');
SQLDBMS_OUTPUT.PUT_LINE(a);
SQLend;
SQL/
Regards
Naveen
Functions CAN be called from SQL*Plus like this ...
create the function
---
create or replace function emp_sel(e IN VARCHAR2) RETURN VARCHAR2 IS
cName VARCHAR2(32);
BEGIN
SELECT INITCAP(ename) INTO cName FROM EMP WHERE ename = e;
RETURN (cName);
END;
/
in SQL*Plus do
this ...
create the function
---
create or replace function emp_sel(e IN VARCHAR2) RETURN VARCHAR2 IS
cName VARCHAR2(32);
BEGIN
SELECT INITCAP(ename) INTO cName FROM EMP WHERE ename = e;
RETURN (cName);
END;
/
in SQL*Plus do the following
Hi,
Can someone shed some light on the differences of gathering statistics on a
function-based index using the following two methods?
method 1: analyze table table_name compute statistics
vs
method 2: create unique index index_name on table_name
(upper(columne_name)) compute statistics;
I could
of Service Status Q/A To Development
Base Bug N/A Fixed in Product Version 10.0.0
Problem statement:
ORA-904:GATHER_TABLE_STATS FAILS ON TABLE WITH WIH FUNCTION-BASED INDEX
*** 02/03/03 10:59 am *** TAR
to list
the contents of user_indexes for the index after each of the analyzes?
At 05:45 AM 6/2/2003 -0800, you wrote:
Hi,
Can someone shed some light on the differences of gathering statistics on
a function-based index using the following two methods?
method 1: analyze table table_name compute
blush! Thanks...
Having been through two books and having aborted the third, I can only
repeat what a friend told me after completing his MBA at night school: You
can work your job, live your life, and go to school. But, only two at a
time...
Substitute write a book for go to school and that
Wolfgang,
Thanks for your respond.
I tried gathering stats on the function based index using
- analyze index ACFD_INDX1 compute statistics;
- exec
dbms_stats.gather_table_stats(ownname='ACPO',tabname='AC_FORWARD_DEST',cascade=TRUE);
- exec dbms_stats.gather_index_stats('ACPO','ACFD_INDX1
Optimizer=CHOOSE (Cost=37 Card=535 Bytes=1605)
1 0 TABLE ACCESS (FULL) OF 'T1' (Cost=37 Card=535 Bytes=1605)
== End test case #1 ===
OK, so we've reproduced your situation. Why didn't it use the index? Are
function-based indexes somehow not working
Cary, I will be first one to get a copy of the book.
And now this is my turn to request Tim ;)
Book! Book! Book!
Jp.
2003/06/02 18:54:38, Cary Millsap [EMAIL PROTECTED] wrote:
To clarify my Book! Book! Book! :)...
This is my request for Tim to write [another] one.
Cary Millsap
--
Please
Tim,
First, i would like to thank U a million.
It was a real GOOD explanation.
I don't know why should you apologize for helping me.
I should be thankful to u for helping me in time.
GREAT to have guys like u in this list.
Knowing is GOOD.
but making others know it , is GREAT.
thanx for your
JP,
In the EXPLAIN PLAN, it says Card=262146, indicating that the query
expects to retrieve over a quarter-million rows. Is that in fact correct?
If so, the CBO is making the correct decision to perform a FULL table scan.
What was the comparison of elapsed times between the two plans, the one
PROTECTED]
Sent: Thursday, May 29, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Function Based Index - Not Used ???
Guys,
create table Tab1 ( name varchar2(100),age int,state
varchar2(100),country varchar2(100));
insert into tab1 values ('SCOTT',25,'TN','India');
I
appropriate
(Bvalue.
(B
(BRegards
(BNaveen
(B
(B
(B
(B -Original Message-
(B From: Prem Khanna J [mailto:[EMAIL PROTECTED]
(B Sent: Thursday, May 29, 2003 12:25 PM
(B To: Multiple recipients of list ORACLE-L
(B Subject: Function Based Index - Not Used ???
(B
(B
(B Guys,
(B
(B
Wow, there sure are a lot of Scott's in India...
-Original Message-
Sent: Thursday, May 29, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
JP,
In the EXPLAIN PLAN, it says Card=262146, indicating that the query
expects to retrieve over a quarter-million rows. Is that in fact
John,
I tried it with COMPATIBLE=8.1.6.
no nulls in that particular column
but it's the same again.
As Tim pointed out,
CARD=262146 -- as per the EXPLAIN PLAN for SELECT w/o HINT.
the SELECT retuens about 2.5 million rows.
which is why it goes for a FTS than a Index scan
is my understanding
Thanks Tim.
But the SELECT returns just 2 of 20,00,000 records.
and the Time elapsed for Index scan is 0.7 secs where as
it is 5 secs for FTS.
Hell a lot of lousy things here Tim.
just mending it one by one.
Regards,
Jp.
2003/05/29 22:30:02, Tim Gorman [EMAIL PROTECTED] wrote:
JP,
In the
AGE
whose value cannot not be found from the index.
Regards
Naveen
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Function Based Index - Not Used ???
John,
I tried
STATEMENT Optimizer=CHOOSE (Cost=37 Card=535 Bytes=1605)
1 0 TABLE ACCESS (FULL) OF 'T1' (Cost=37 Card=535 Bytes=1605)
== End test case #1 ===
OK, so we've reproduced your situation. Why didn't it use the index? Are
function-based indexes somehow not working
Wow, too good!
-Original Message-
From: Tim Gorman [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Function Based Index - Not Used ???
JP,
I apologize in advance for the long email, but I think you'll find
=535 Bytes=1605)
== End test case #1 ===
OK, so we've reproduced your situation. Why didn't it use the index? Are
function-based indexes somehow not working? Or is the CBO choosing a FULL
table scan instead?
Here is some information to consider
Guys,
create table Tab1 ( name varchar2(100),age int,state varchar2(100),country
varchar2(100));
insert into tab1 values ('SCOTT',25,'TN','India');
I have 20,00,000 records like above.
create index idx1 on tab1 (upper(name));
analyze table tab1 compute statistics;
analyze index idx1 compute
-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Function Based Index - Not Used ???
Guys,
create table Tab1 ( name varchar2(100),age int,state
varchar2(100),country varchar2(100));
insert
Oops! didnot read your full message.
try setting OPTIMIZER_INDEX_COST_ADJ with alter session to a lower value
Regards
Naveen
-Original Message-
From: Naveen Nahata
Sent: Thursday, May 29, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Function Based Index
chk in V$access table
--
On Tue, 01 Apr 2003 06:43:36
Chaim.Katz wrote:
Hi,
Is there a way to see whose function a user is executing?
Development and production schemas exist on the same database and both
accounts have granted object privileges to the user roles. (I think public
synonyms
Title: RE: Whose function is executing.
The best way is to login as the user and then use resolve the object in question.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Title: RE: Whose function is executing.
Could this script from Ixora help?
How can I tell if a procedure/package is running?
http://www.ixora.com.au/q+a/0110/30141015.htm
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Is there a way to see whose
Try using PL/SQL tracing , available in Oracle8i and Oracle9i.
DBMS_TRACE.SET_PLSQL_TRACE (trace_level INTEGER).
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database
Hi,
Is there a way to see whose function a user is executing?
Development and production schemas exist on the same database and both
accounts have granted object privileges to the user roles. (I think public
synonyms are being used). I'm wondering if there is a way to check that a
user
recipients of list ORACLE-L
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you
within that week. Is there a function to do this in SQL???
Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get the last
day of the week and use ranges for your task or using any 'pivot'-approach
(you need 7 rows) you can
I have found out the reasons. Thanks for your information.
That's good.
P.S.: 27 of Nov is my birthday. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ:
Thanks a lot!!!
-Original Message-
Sent: Saturday, March 29, 2003 1:09 AM
To: Multiple recipients of list ORACLE-L
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using
Hi,
Given a week between (1 - 52) for a particular year can we get all the dates within
that week. Is there a function to do this
in SQL
. Anything smarter,
somebody ?
Given a week between (1 - 52) for a particular year
can we get all the dates within that week. Is there
a function to do this
in SQL???
Thanks a lot.
Regards
Sesi
--
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
the idea.
Anything smarter, somebody ?
Given a week between (1 - 52) for a particular year
can we get all the dates within that week. Is there
a function to do this
in SQL???
Thanks a lot.
Regards
Sesi
--
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http
pivot_table;
drop type pivot_row;
CREATE OR REPLACE TYPE pivot_row AS OBJECT (
x NUMBER
);
/
CREATE OR REPLACE TYPE pivot_table
AS TABLE OF pivot_row;
/
CREATE OR REPLACE PACKAGE pivot_package AS
FUNCTION pivot (num_rows IN NUMBER)
RETURN pivot_table
PARALLEL_ENABLE PIPELINED;
END;
/
CREATE
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get
Title: RE: WinNT / 8.0.5 / DECODE function affecting Century result in date
I just did a test on the decode and
"DECODE('301230,NULL,NULL,TO_DATE('19'||'301230','MMDD'))")
returned 1930/12/30 as required while
"DECODE('301230,NULL,NULL,TO_DATE('301230','MMDD'))")
Title: RE: WinNT / 8.0.5 / DECODE function affecting Century result in date
I don't understand the question. It seems to me that the date conversion is acting as expected.
to_date ('301231', 'YYMMDD') should be 31 December 2030. If you don't specify a century, the century defaults
I have written a function to return a drug price from our database. If I use
this function in a SQL statement it take a long time to return a value.
However running the main cursor in the function in SQL returns a value
immediately. DOing a little debugging I find that the function does 6000
Alec,
Have a look at the 2 explain plans and see how they are different.
Have a look at wait stats / 10046 trace for the two and see how they are different.
What version of Oracle?
Do you have histograms?
If 8i or below and using the function then you will be using bind values and not
getting
Hi all-
I am trying to write a query that strips carriage returns from a comment
field while selecting the data to a file. I have used the following
command -
select replace( field1, chr(10), '*' ) from table1;
The query seems to remove the carriage returns when returning the data via
Yes. CHR(10) is linefeed (LF). CHR(13) is carriage return (CR, aka
^M).
Enjoy! :)
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Wednesday, March 19, 2003 3:29 PM
To:
Thanks-
I realized that just a minute ago. It's been a long day!
Wendy Hopper
*248-696-6193 (Onstar) / 248-696-2390 (New King)
* [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 19, 2003 4:58 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Yes. CHR(10) is linefeed
Title: RE: Oracle REPLACE function and carriage returns
Have you tried a select dump (field1) from table1 to see what ascii code corresponds to what you think is a carriage return?
-Original Message-
From: Hopper, Wendy S [mailto:[EMAIL PROTECTED]]
I am trying to write a query
Hello
list,
I want
to find the difference between 2 dates..
Any Oracle function
for that ???
Thanks and Regards,
Santosh
')
1.28016204
You can then convert the decimal portion to hours, minutes, seconds as
you wish.
Dennis
Santosh Varma wrote:
Hello list,
I want to find the difference between 2 dates..
Any Oracle function for that ???
Thanks and Regards,
Santosh
--
Please see
function
Hello
list,
I
want to find the difference between 2 dates..
Any Oracle
function for that ???
Thanks and Regards,
Santosh
How about just subtracting them?
Santosh Varma wrote:
Hello
list,
I
want to find the difference between 2 dates..
Any Oracle
function for that ???
Thanks and Regards,
Santosh
PROTECTED]Envoyé: lundi 10 mars 2003
10:39À: Multiple recipients of list
ORACLE-LObjet: Date difference function
Hello
list,
I
want to find the difference between 2 dates..
Any Oracle
function for that ???
Thanks and Regards,
Santosh
Santosh,
What granularity do you need? Number of days? or Number of days, hours,
minutes, seconds?
Santosh Varma wrote:
Hello
list,
I
want to find the difference between 2 dates..
Any Oracle
function for that ???
Thanks and Regards
[mailto:[EMAIL PROTECTED]
Envoyé : lundi 10 mars 2003 10:39
À : Multiple recipients of list ORACLE-L
Objet : Date difference function
Hello list,
I want to find the difference between 2 dates..
Any Oracle function for that ???
Thanks and Regards,
Santosh
--
Please
Chris,
This is exactly what extensible indexing was created for. The idea is simple:
You implement an effective search (typically involving some helper tables/indexes),
and you express your "search" using a function in SQL, that will call out
to your implementation. The actual impl
Title: RE: Oh Where Oh Where Is My Redo Coming From
I don't think this is possible but I
would like to confirm here.
I would like to create a function based
index to speed up the OH SO SLOW query that follows:
SELECT dmzu.ZIP_CODE
FROM dm_zip_unq dmzu
WHERE fnc_dist(some
21, 2003
2:55 PMTo: Multiple recipients of list ORACLE-LSubject:
function based indexes.
I don't think this is
possible but I would like to confirm here.
I would like to
create a function based index to speed up the OH SO SLOW query that
follows:
SELECT
dmzu.ZIP_CODE
Because I'm picky. I ruled out OracleTool because it's web-based. While it
may be an advantage at times (don't need to install on every machine I use),
it's a whole number of layers I don't want to troubleshoot when in Crisis
Mode.
OraC is pretty cool. I looked at it when I got O'Reilly's
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Perl - Was Unix time conversion function
Because I'm picky. I ruled out OracleTool because it's web-based. While
it
may be an advantage at times (don't need to install on every machine I
use),
it's a whole number
Title: unix time conversion function
Cary I once thought I wanted to do some Perl coding... So I bought a
book and started to play with it. It made my head bleed... literally I had
little droplets of blood emerging from my head They rushed me to the
hospital and put me in the Perl
Title: unix time conversion function
I think its like almost any subjective
idea: its beautiful if you love it, heinous if you hate it.
I love Perl; it does what I mean. The only
thing I really dont like about Perl 5 is its yucky way of supporting complex
data structures. Im eager
about Perl or am I a lone wolf in a Perl
world?
RF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
At the risk of stating the obvious, doing it in Perl
Title: RE: Perl - Was Unix time conversion function
I used to be, but I finally bit the bullet ... I ordered my copy of Jared's book from Amazon.com yesterday !!
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
in a Perl
world?
RF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
At the risk of stating
wolf in a Perl
world?
RF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
At the risk of stating
Perl kind of makes sense but I haven't reached the point where it clicks and
becomes natural. I still need to think about it very hard when I'm writing
it. Hence, a lot of the time I fall back on shell scripts supplemented by
pre-written (some would say shamelessly ripped off) perl code for the
Title: unix time conversion function
Now
that's what I call a "Perl Breakdown!!"...A nervous breakdown brought on
by pathological eclecticism. The cure for this is a healthy dose of Python. It
is truly refreshing!!
Steve
Orr
Oracle
DBA and part-time Python Evangelist.
---
,
and maybe a dash of egrep. When you finally are comfortable with
co-processes (aaaugh!!), then you are ready to start on Perl. Not that Perl
has anything as goofy as co-processes; but if you can do that, you should be
ready for Perl. The ksh function definition and calling as vaguely similar
For me, it was either Perl or an icky bass-ackward pipe-laden awk/sed/regex
unmaintainable bastion. OK, I couldn't get rid of the regex. While I'll
not be entering the Obfuscated Perl contest anytime soon, I think Perl is
much easier to understand for a traditional programmer (Assembly, BASIC,
world?
RF
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
At the risk of stating the obvious
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cary
Millsap
Sent: Friday, January 24, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: unix time conversion function
At the risk of stating the obvious, doing it in Perl looks like
1 - 100 of 400 matches
Mail list logo