| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dynamic list-like stuff in PL/SQL
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C05AE0.FD413EA0
Content-Type: text/plain;
charset="iso-8859-1"
You do not need pointers to implement link list. Instead you can have PL/SQL table of records one of columns will ne index of next and/or previous record. This will give you all functionality of link list.
Alex Hillman
-----Original Message-----
From: Jamadagni, Rajendra [mailto:rajendra.jamadagni_at_espn.com]
Sent: Thursday, November 30, 2000 8:35 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Dynamic list-like stuff in PL/SQL
I don't know what is meant by dynamic chained list is, but if it is anything comparable to a linked list as in 'C', you can use PL/SQL tables to implement it. It will be a crude implementation as there is no concept of pointers in Oraclespeak.
PL/SQL tables are a sparse collection type so (probably) they are a good candidate for such implementations.
HTH
Raj
This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: rajendra.jamadagni_at_espn.com 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-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Nov 30 2000 - 09:19:53 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C05AE0.FD413EA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Dynamic list-like stuff in PL/SQL</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>You do not need pointers to implement link list. = Instead you can have PL/SQL table of records one of columns will ne = index of next and/or previous record. This will give you all = functionality of link list.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jamadagni, Rajendra [<A = HREF=3D"mailto:rajendra.jamadagni_at_espn.com">mailto:rajendra.jamadagni_at_es= pn.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, November 30, 2000 8:35 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Dynamic list-like stuff in = PL/SQL</FONT> </P> <BR> <P><FONT SIZE=3D2>I don't know what is meant by dynamic chained list = is, but if it is anything</FONT> <BR><FONT SIZE=3D2>comparable to a linked list as in 'C', you can use = PL/SQL tables to</FONT> <BR><FONT SIZE=3D2>implement it. It will be a crude implementation as = there is no concept of</FONT> <BR><FONT SIZE=3D2>pointers in Oraclespeak.</FONT> </P> <P><FONT SIZE=3D2>PL/SQL tables are a sparse collection type so =
(probably) they are a good</FONT>
<BR><FONT SIZE=3D2>candidate for such implementations.</FONT> </P> <P><FONT SIZE=3D2>HTH</FONT> <BR><FONT SIZE=3D2>Raj</FONT> <BR><FONT = SIZE=3D2>______________________________________________________</FONT> <BR><FONT SIZE=3D2>Rajendra Jamadagni = MIS, ESPN Inc.</FONT> <BR><FONT SIZE=3D2>Rajendra dot Jamadagni at ESPN dot com</FONT> <BR><FONT SIZE=3D2>QOTD: Any clod can have facts, but having an opinion = is an art !</FONT> <BR><FONT SIZE=3D2>Any opinion expressed here is personal and doesn't = reflect that of ESPN Inc.</FONT> </P> <BR> <P><FONT = SIZE=3D2>***************************************************************= ******</FONT> </P> <P><FONT SIZE=3D2>This e-mail message is confidential, intended only = for the named recipient(s) above and may contain information that is = privileged, attorney work product or exempt from disclosure under = applicable law. If you have received this message in error, or are not = the named recipient(s), please immediately notify ESPN at (860) = 766-2000 and delete this e-mail message from your computer, Thank = you.</FONT></P> <P><FONT = SIZE=3D2>***************************************************************= ******</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jamadagni, Rajendra</FONT> <BR><FONT SIZE=3D2> INET: rajendra.jamadagni_at_espn.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT>
 |
 |