skip to main
|
skip to sidebar
Oracle In Me
Wednesday, December 23, 2009
XML Data : loading xml data into xml table and retrieving the same
LOAD DATA
INFILE *
INTO TABLE po_tab
APPEND
XMLTYPE (xmldata)
FIELDS
(xmldata CHAR(2000))
create table abc (a xmltype)
select * from abc
insert into abc values (xmltype('
234
tt
'))
select extractvalue(a,'/st/b') "aaa" from abc
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Labels
Functional Learning
(2)
Functional Queries
(1)
Matrix Begins
(1)
OAF
(14)
Oracle Forms
(1)
Others
(4)
PL/SQL
(1)
SQL Queries
(4)
Workflow
(8)
XML Publisher
(8)
Followers
Blog Archive
►
2011
(2)
►
March
(2)
►
2010
(28)
►
October
(3)
►
September
(1)
►
July
(1)
►
June
(7)
►
May
(2)
►
April
(4)
►
March
(2)
►
February
(4)
►
January
(4)
▼
2009
(34)
▼
December
(6)
Oracle Workflow Notification System
XML Data : loading xml data into xml table and ret...
Workflow Notification Mailer Attributes
Oracle API's
Some Metalink notes for Diagnosing Module wise Wor...
How to provide drop down list in a notification me...
►
November
(8)
►
October
(1)
►
August
(3)
►
July
(2)
►
June
(3)
►
May
(11)
About Me
Jaison Kochery
View my complete profile
No comments:
Post a Comment