Skip to content

Instantly share code, notes, and snippets.

<ROOT>
<A>
<B1>lineB11</B1>
<B2>lineB12</B2>
<B3>lineB13</B3>
<B4>lineB14</B4>
</A>
<A>
<B1>lineB21</B1>
<B2>lineB22</B2>
@crazycloud
crazycloud / data_structure.sql
Created July 25, 2012 10:38
PL sql package to solve easy and medium sudoku
--create cell
CREATE TYPE cell AS OBJECT (
actual_value number,
poss_values possible_values
)
--create nested table of possible values
CREATE TYPE possible_values AS TABLE OF number;
CREATE OR REPLACE PACKAGE BODY demo_mail
IS
-- Return the next email address in the list of email addresses, separated
-- by either a "," or a ";". The format of mailbox may be in one of these:
-- someone@some-domain