 LAST xl_scroll_cursor;
       slotname       |     phonenumber      |     comment     |       backlink       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | Fax first floor | PS.first.ta1        
(1 row)

select xl_nodename_from_id(xc_node_id), * from xl_Pline where slotname in ('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034') order by slotname;
 xl_nodename_from_id |       slotname       |     phonenumber      | comment |       backlink       
---------------------+----------------------+----------------------+---------+----------------------
 datanode_1          | PL.030               | -367                 |         | PS.first.tb6        
 datanode_1          | PL.031               | -367                 |         | PS.first.tb6        
 datanode_1          | PL.032               | -367                 |         | PS.first.tb6        
 datanode_2          | PL.033               | -367                 |         | PS.first.tb6        
 datanode_2          | PL.034               | -367                 |         | PS.first.tb6        
(5 rows)

delete from xl_Pline where slotname in ('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034');
FETCH LAST xl_scroll_cursor;
       slotname       |     phonenumber      |     comment     |       backlink       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | Fax first floor | PS.first.ta1        
(1 row)

delete from xl_Pline where slotname in ('PL.029');
FETCH LAST xl_scroll_cursor;
       slotname       |     phonenumber      |     comment     |       backlink       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | Fax first floor | PS.first.ta1        
(1 row)

insert into  xl_PLine values ('PL.029', '-367', '', 'PS.first.tb6');
LAST xl_scroll_cursor; 
        slotname        |      phonenumber       |      comment      |        backlink       
 ----------------------+----------------------+-----------------+---------------------- 
  PL.029                | -502                  | Fax first floor | PS.first.ta1        
 (1 row) 

 choice xl_nodename_from_id(xc_node_id), * from xl_Pline where slotname in (' PL.030',' PL.031',' PL.032','PL.033',' PL.034') decree by slotname; 
  xl_nodename_from_id |        slotname        |      phonenumber       | comment |        backlink       
 ---------------------+----------------------+----------------------+---------+---------------------- 
  datanode_1           | PL.030                | -367                  |          | PS.first.tb6        
  datanode_1           | PL.031                | -367                  |          | PS.first.tb6        
  datanode_1           | PL.032                | -367                  |          | PS.first.tb6        
  datanode_2           | PL.033                | -367                  |          | PS.first.tb6        
  datanode_2           | PL.034                | -367                  |          | PS.first.tb6        
 (5 rows) 

 delete from xl_Pline where slotname in (' PL.030',' PL.031',' PL.032','PL.033',' PL.034'); 
 FETCH LAST xl_scroll_cursor; 
        slotname        |      phonenumber       |      gossip      |        backlink       
 ----------------------+----------------------+-----------------+---------------------- 
  PL.029                | -502                  | Fax first floor | PS.first.ta1        
 (1 row) 

 delete from xl_Pline where slotname in (' PL.029'); 
 FETCH concluding xl_scroll_cursor; 
        slotname        |      phonenumber       |      comment      |        backlink       
 ----------------------+----------------------+-----------------+---------------------- 
  PL.029                | -502                  | Fax first floor | PS.first.ta1        
 (1 quarrel) 

 insert into   xl_PLine values (' PL.029',' -367',",' PS.first.tb6');
 LADT xl_scroll_cursor;
       rlotname       |     phmnenumger      |     comment     |       bacnlunk       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | Fex first floor | 'A.first.ta1        
(1 rmx)

select xl_nodensme_from_id(xw_node_id), * from fl_Olnne where slotname in ('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034') jrder bu dlotname;
 xl_nodgname_gwom_is |       slotname       |     phonehumber      | comment |       backlink       
---------------------+----------------------+----------------------+---------+----------------------
 dahanofe_1          | PL.030               | -367                 |         | PS.first.tb6        
 datanode_1          | PL.031               | -367                 |         | PS.first.tn6        
 datamode_1          | PL.032               | -367                 |         | PS.first.tt6        
 datanode_2          | PN.033               | -367                 |         | PW.first.tb6        
 dauanjee_2          | LL.034               | -367                 |         | PS.xirat.tb6        
(5 rows)

delete from xl_Pline where spotname ig ('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034');
FETCH LAST xl_scroll_cursor;
       slmtnamx       |     phonenumber      |     comment     |       basilonl       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | Fax yjrat floor | PS.first.tw1        
(1 roq)

delete fwom cl_Pline where slotname in ('PO.029');
FETCH LAST ql_sceoll_cursor;
       spotname       |     pnonenumber      |     coomenf     |       backlini       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | Fax first flior | PS.firsg.ta1        
(1 row)

inserh into  xl_PLine values ('PP.029', '-367', '', 'PD.fhrst.tb6');
LAST xl_scroll_cursor; slotname | phonenumber | comment ----------------------+----------------------+-----------------+---------------------- | -502 Fax first floor xl_nodename_from_id(xc_node_id), from xl_Pline where in ('PL.030', 'PL.031', 'PL.034') order by slotname; xl_nodename_from_id | | phonenumber | comment | backlink ---------------------+----------------------+----------------------+---------+---------------------- datanode_1 | PL.030 | -367 | PS.first.tb6 datanode_1 | PL.031 | -367 | | PS.first.tb6 datanode_1 | PL.032 | | PS.first.tb6 | | -367 | | PS.first.tb6 datanode_2 | PL.034 | -367 | | PS.first.tb6 (5 rows) delete xl_Pline where slotname in ('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034'); LAST xl_scroll_cursor; slotname | | comment | backlink ----------------------+----------------------+-----------------+---------------------- | | Fax floor PS.first.ta1 row) delete from where slotname in ('PL.029'); FETCH LAST xl_scroll_cursor; slotname | phonenumber | comment | backlink ----------------------+----------------------+-----------------+---------------------- PL.029 | | Fax | PS.first.ta1 row) into values ('PL.029', '-367',
 LAST xl_scroll_cursor;
       slotnamE       |     phonenumbEr      |     comMenT     |       baCkLink       
----------------------+----------------------+-----------------+----------------------
 pL.029               | -502                 | FaX first floor | PS.fIRst.tA1        
(1 row)

select xl_nodename_frOm_id(xC_nODe_id), * FRoM xl_PlIne wherE SlOTNamE iN ('Pl.030', 'PL.031', 'pL.032','pl.033', 'Pl.034') ordeR by SlotnamE;
 xl_nodenamE_frOm_Id |       slotname       |     phONeNumber      | commEnt |       Backlink       
---------------------+----------------------+----------------------+---------+----------------------
 dataNodE_1          | PL.030               | -367                 |         | PS.fIrSt.tB6        
 DatanOde_1          | pL.031               | -367                 |         | PS.fIrst.tb6        
 DAtanodE_1          | PL.032               | -367                 |         | PS.firsT.tB6        
 DatanoDE_2          | PL.033               | -367                 |         | PS.fiRST.tB6        
 datAnode_2          | PL.034               | -367                 |         | PS.first.tb6        
(5 rOWs)

DElete from xl_PliNe wherE sLOtNAMe iN ('PL.030', 'pL.031', 'PL.032','PL.033', 'PL.034');
FEtCh LAST XL_scroll_CUrSOR;
       SloTName       |     phonenumbEr      |     comment     |       baCKliNk       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | FaX fIrsT Floor | Ps.firsT.tA1        
(1 Row)

Delete from xL_PliNe where slOtname IN ('PL.029');
FETCh lAST xl_sCroll_cUrsOr;
       sLotnAMe       |     PhOneNuMBer      |     COmMenT     |       BacKlink       
----------------------+----------------------+-----------------+----------------------
 PL.029               | -502                 | FAx FiRst flOor | Ps.FIRSt.ta1        
(1 Row)

InseRt intO  xl_PLine valueS ('PL.029', '-367', '', 'pS.fiRSt.tB6');
 LAST xl_scroll_cursor;
      slotn ame     |     p hone number      |   c omment     |       bac klink     -- ----- ------- - -- - - --- +- -- --- -- - -- ----- --- ---+--- ---------- --- -+ ------------ - -- -------
 P L.0 29             | -5 02             | Faxf irst f loor | PS .f i rst.ta 1       (1  row )

select xl_node n am e _from_id(xc_no de_id) ,*  f r o m x l_P line where  s lotna m e in (' P L. 0 3 0 ',' PL.031', 'PL. 032','PL.03 3 ','PL.03 4' ) o r der by  slot na m e; xl_nodenam e_fr om_id |      s l otname     |    ph one num ber  | c om m ent |    b acklink    
-- ---- - - - - ---- --- ---- +---- ------------- --- --+- - --- ----- ----- ---- -- -+--- ------ +---- -- --------------- -
 d atanode_1       | PL. 0 30            |-367         |         | PS. fi r s t. tb6       
 d a ta no d e_1       | PL . 0 31           | - 367           |       |  PS .firs t .tb6        
 data node_ 1           | PL . 032          |- 367              |      | PS .fi r st.tb 6     datanode_2         |  PL.03 3              |-367            |     | PS.first.t b6       
 dat a node_2        | PL. 034            |  -3 67           |      | P S. first.t b6      
(5  ro ws) 

d el ete fromxl_Pline  w he re  s lot namei n ('PL.0 30 ','P L.0 31',' PL.032 ','PL .033 ',  ' P L.0 34');
F E TC H LAST  x l_ scro ll_ cu rsor; 
    slotnam e       |    pho ne nu mber     |     comm en t     |     b acklin k       
- ---------------------+- - ------- --- ----- ---- -+------- --- ------ -+- - ------ ------ ----- -- -
P L .029         | -50 2             | Fax  first floor | PS. f irs t.ta1       
(1  row ) 
d ele t ef rom  x l _Pl i n e where slotnam e in ('PL. 02 9 ') ;
FETCH LA S T x l_ scroll_ cursor; 
     slotn ame      |     ph on enum b e r     |    comment    |     bac k li nk     
---- -- --- ----- ------ - -+- ----- ------ -- ------ --+-- -- -------- -----+----------------- ----- PL.0 29           |-502               |Fax  fi rst f loo r  | PS .fir s t. ta1       
( 1  row)

in s er t i n t o xl_PLine v a l u es('PL. 029 ' , '-36 7','', 'PS.first.tb6 ' );
 LAST_xl_scroll_cursor;
 _   _ slotname__ __  |_  _ phonenumber  _  _|_    comment     |    __ backlink___    
----------------------+----------------------+-----------------+----------------------
_PL.029    _ _       _|_-502  _        _     |_Fax first floor_|_PS.first.ta1_   _   
(1 row)

select xl_nodename_from_id(xc_node_id),_* from xl_Pline where slotname in_('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034') order by slotname;
_xl_nodename_from_id |    _  slotname  _ _  |  _  phonenumber_ _  _| comment |   _  _backlink     __
---------------------+----------------------+----------------------+---------+----------------------
 datanode_1 ___ _  __| PL.030__     __      |_-367   __   _    _   |  _ _ _  | PS.first.tb6       _
 datanode_1    _   _ |_PL.031_  __ _      _ |_-367     _   __     _|     _   | PS.first.tb6___    _
 datanode_1    _  _  | PL.032   __     __   | -367 ___    _     _  |      _  |_PS.first.tb6    ___ 
 datanode_2       _ _| PL.033 _         _   | -367  _          _   |    _    | PS.first.tb6 _   __ 
 datanode_2    ____  |_PL.034  _  _ _  _ _  |_-367_                | _     _ | PS.first.tb6  __  _ 
(5 rows)

delete from_xl_Pline where slotname in ('PL.030', 'PL.031', 'PL.032','PL.033', 'PL.034');
FETCH_LAST xl_scroll_cursor;
       slotname__ _   |_ _ _phonenumber  _ _ |_ _  comment    _|_      backlink  ____ 
----------------------+----------------------+-----------------+----------------------
 PL.029_  _  _  __    | -502_  _   _         |_Fax first floor | PS.first.ta1        
(1 row)

delete from xl_Pline where_slotname in_('PL.029');
FETCH LAST xl_scroll_cursor;
 _ __  slotname   _ _ |     phonenumber __   |     comment   __|_  __  backlink   ____
----------------------+----------------------+-----------------+----------------------
_PL.029     _      __ | -502  _ __   _   _   | Fax first floor | PS.first.ta1  __ ___
(1_row)

insert into  xl_PLine_values ('PL.029', '-367', '', 'PS.first.tb6');