OraFAQ Forum: JDeveloper, Java & XML » Problem querying XML in CLOB column

Home » Developer & Programmer » JDeveloper, Java & XML » Problem querying XML in CLOB column (SQL*Plus: Release 9.0.1.3.0 - Unknown OS.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem querying XML in CLOB column [message #500082]

Thu, 17 March 2011 12:58

aileron
Messages: 3
Registered: March 2011

Junior Member

Hi,

I'm new to this forum and I'm hoping someone here can help me out.

I have spent days trying to figure this out. I must warn you I'm new to Oracle as my past experience (years ago) was with Mysql and Postgres sql on Linux and I've been out of IT for years. Now I'm a lowly engineer and because of budget cuts I'm forced to do this because our IT department is going away.

So the problem... I have a CLOB column called XML_DATA that has (not-surprisingly) xml data in it that's housed inside a table called HMS_XML_TRANSFER. It has been giving me a headache because I'm unable at this point to use the xml field as a condition to get its TRANS_SEQUENCE number. The where clause doesn't work.

SELECT TRANS_SEQUENCE, XML_DATA
FROM HMS_XML_TRANSFER
WHERE EXTRACTVALUE(XMLTYPE (XML_DATA), '/INTERFACES/INTERFACE/BODY/IFI0057[ACTIVITY_CODE = "2201-020742"]');

The only test that I have been able to get working is the one below.

SELECT TRANS_SEQUENCE, EXTRACTVALUE(XMLTYPE (XML_DATA), '/INTERFACES/INTERFACE/BODY/IFI0057/ACTIVITY_CODE')
FROM HMS_XML_TRANSFER
WHERE TRANS_SEQUENCE = '8191602';

It will give me the ACTIVITY_CODE element so I know I can pull data from the XML but I can't do the reverse in the first example which is what I need because I don't know the TRANS_SEQUENCE number, I just know the ACTIVITY_CODE.

I have over 202 error messages logged in Teradata SQL from my many and varied attempts to get this to work using every example I could find online.

As an example this has not worked either...

WHERE EXISTNODE(XML_DATA, '/INTERFACES/INTERFACE/BODY/IFI0057[ACTIVITY_CODE = "2201-020742"]') = 1;

So the question... How do I properly form my SQL statement so I can use the XML column's ACTIVITY_CODE element to get the TRANS_SEQUENCE column field? Oh and I'd like to see both columns in the result.

Thanks in advance to any Guru's that can help out.

Below is the version of Oracle I'm using, the description of the Table HMS_XML_TRANSFER, and a sample of the XML that comes from XML_DATA. I can't seems to get tabs working sorry. :(

===============
ORACLE VERSION
===============
SQL*Plus: Release 9.0.1.3.0 - Production on Thu Mar 17 08:18:15 2011

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

=========================
TABLE HMS_XML_TRANSFER
=========================

Name            Null?        Type
--------------- ---------    --------------
TRANS_TYPE      NOT NULL     VARCHAR2(10)
DATE_IN         NOT NULL     DATE
DATE_PROCESSED               DATE
STATUS                       VARCHAR2(8)
ERROR_MSG                    VARCHAR2(2000)
TRANS_SEQUENCE               NUMBER(38)
SITE_CODE                    VARCHAR2(20)
COMMAND                      VARCHAR2(2000)
[b]XML_DATA                  CLOB[/b]

========================
XML in COLUMN XML_DATA
========================

<INTERFACES>
<INTERFACE>
<HEADER>
<INTERFACE_NAME>CREATE_UPDATE_PLAN_ACTIVITY</INTERFACE_NAME>
<EXTERNAL_APP_NAME>SILVER</EXTERNAL_APP_NAME>
<EXTERNAL_APP_ID>INTFCE</EXTERNAL_APP_ID>
</HEADER>
<BODY>
<IFI0057>
<CUSTOMER_ID>SAP</CUSTOMER_ID>
<ACTIVITY_CODE>2201-020742</ACTIVITY_CODE>
<CODE_DESCRIPTION>BRACKET INSTALL</CODE_DESCRIPTION>
<ACTIVITY_TYPE>Z</ACTIVITY_TYPE>
<ACTIVITY_GROUP>1110</ACTIVITY_GROUP>
<SHORT_DESCRIPTION>BRAC</SHORT_DESCRIPTION>
<LAST_CHG_DATETIME>20110309</LAST_CHG_DATETIME>
<STATUS>COMPLETE</STATUS>
<EST_MATERIAL_COST></EST_MATERIAL_COST>
<EST_LABOR_HOURS>8</EST_LABOR_HOURS>
<EST_DAYS></EST_DAYS>
<USER_REF1>5</USER_REF1>
<USER_REF2>CD-11001-007</USER_REF2>
<USER_REF3></USER_REF3>
<USER_REF4></USER_REF4>
<USER_REF5></USER_REF5>
<USER_REF6></USER_REF6>
<USER_REF7></USER_REF7>
<USER_REF8></USER_REF8>
<PLAN_TYPE>INSTALL</PLAN_TYPE>
<ALT_PLAN> </ALT_PLAN>
<MODEL>SUPERX</MODEL>
<DEPARTMENT>010ZD</DEPARTMENT>
<WBS_CLIN>1.1.2</WBS_CLIN>
<IFI005701>
<CUSTOMER_ID>SAP</CUSTOMER_ID>
<ACTIVITY_CODE></ACTIVITY_CODE>
<MASTER_FORM_CODE></MASTER_FORM_CODE>
<MASTER_FORM_TYPE>WO</MASTER_FORM_TYPE>
</IFI005701>
<IFI005702>
<CUSTOMER_ID>SAP</CUSTOMER_ID>
<DEFAULT_ORDER>2201-020742</DEFAULT_ORDER>
<DEF_TYPE></DEF_TYPE>
<DEF_DESCRIPTION></DEF_DESCRIPTION>
<DEF_JDD_SCENARIO></DEF_JDD_SCENARIO>
<PRIORITY></PRIORITY>
<REPAIR_TYPE></REPAIR_TYPE>
<BUYER></BUYER>
<WHEN_DISCOVERED></WHEN_DISCOVERED>
<HOW_MAL></HOW_MAL>
<TCN></TCN>
<PARTS_REQUIRED>T</PARTS_REQUIRED>
<PART></PART>
<MFG_MIN_QTY></MFG_MIN_QTY>
<MFG_SETUP_TIME></MFG_SETUP_TIME>
<MFG_RUN_TIME></MFG_RUN_TIME>
<MFG_LOT_PREFIX></MFG_LOT_PREFIX>
</IFI005702>
<IFI005703>
<CUSTOMER_ID>SAP</CUSTOMER_ID>
<STRUCTURE_CODE>SUPERX</STRUCTURE_CODE>
<SUB_STRUCTURE_CODE></SUB_STRUCTURE_CODE>
<POS></POS>
<PART></PART>
<REMARKS></REMARKS>
<CREATED_USERID></CREATED_USERID>
<CREATED_DATETIME></CREATED_DATETIME>
<LAST_CHANGED_USERID></LAST_CHANGED_USERID>
<LAST_CHANGED_DATETIME></LAST_CHANGED_DATETIME>
<IFI00570301>
<CUSTOMER_ID>SAP</CUSTOMER_ID>
<EFF_FROM>SX001</EFF_FROM>
<EFF_THRU>SX010</EFF_THRU>
</IFI00570301>
</IFI005703>
</IFI0057>
</BODY>
</INTERFACE>
</INTERFACES>

[Updated on: Thu, 17 March 2011 13:13] by Moderator

Report message to a moderator

Re: Problem querying XML in CLOB column [message #500088 is a reply to message #500082]

Thu, 17 March 2011 13:19

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not clear in what value you want from which part.
What is the condition?
What should be the result?

It also help if you post an indented XML data (1 blank before each subsequent level) and before Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Are you sure you want to version 9.0, it was the biggiest version Oracle ever released, even if you can get the correct query you are not sure it will work in this version.

Regards
Michel

Report message to a moderator

Re: Problem querying XML in CLOB column [message #500112 is a reply to message #500088]

Thu, 17 March 2011 15:14

aileron
Messages: 3
Registered: March 2011

Junior Member

Sorry, Yea I had the XML indented, it flattened on me. Didn't catch the how to format section of your FAQ... My Bad. Sad

The condition is I have an <ACTIVITY_CODE> tag inside the XML_DATA column field and I need to ask the question: what is the TRANS_SEQUENCE number for that row of the table where the ACTIVITY_CODE = 2201-020742 inside the XML document.

The result should look like so:

|---------------|------------|
|TRANS_SEQUENCE | XML_DATA   |
|---------------|------------|
|8191602        | 2201-020742|
----------------|------------|

Formatted XML... sorry. Sad

========
XML DATA
========
<INTERFACES>
 <INTERFACE>
  <HEADER>
   <INTERFACE_NAME>CREATE_UPDATE_PLAN_ACTIVITY</INTERFACE_NAME> 
   <EXTERNAL_APP_NAME>SILVER</EXTERNAL_APP_NAME> 
   <EXTERNAL_APP_ID>INTFCE</EXTERNAL_APP_ID> 
  </HEADER>
  <BODY>
   <IFI0057>
    <CUSTOMER_ID>SAP</CUSTOMER_ID> 
    <ACTIVITY_CODE>2201-020742</ACTIVITY_CODE> 
    <CODE_DESCRIPTION>BRACKET INSTALL</CODE_DESCRIPTION> 
    <ACTIVITY_TYPE>Z</ACTIVITY_TYPE> 
    <ACTIVITY_GROUP>1110</ACTIVITY_GROUP> 
    <SHORT_DESCRIPTION>BRAC</SHORT_DESCRIPTION> 
    <LAST_CHG_DATETIME>20110309</LAST_CHG_DATETIME> 
    <STATUS>COMPLETE</STATUS> 
    <EST_MATERIAL_COST /> 
    <EST_LABOR_HOURS>8</EST_LABOR_HOURS> 
    <EST_DAYS /> 
    <USER_REF1>5</USER_REF1> 
    <USER_REF2>CD-11001-007</USER_REF2> 
    <USER_REF3 /> 
    <USER_REF4 /> 
    <USER_REF5 /> 
    <USER_REF6 /> 
    <USER_REF7 /> 
    <USER_REF8 /> 
    <PLAN_TYPE>INSTALL</PLAN_TYPE> 
    <ALT_PLAN /> 
    <MODEL>SUPERX</MODEL> 
    <DEPARTMENT>010ZD</DEPARTMENT> 
    <WBS_CLIN>1.1.2</WBS_CLIN> 
    <IFI005701>
     <CUSTOMER_ID>SAP</CUSTOMER_ID> 
     <ACTIVITY_CODE /> 
     <MASTER_FORM_CODE /> 
     <MASTER_FORM_TYPE>WO</MASTER_FORM_TYPE> 
    </IFI005701>
    <IFI005702>
     <CUSTOMER_ID>SAP</CUSTOMER_ID> 
     <DEFAULT_ORDER>2201-020742</DEFAULT_ORDER> 
     <DEF_TYPE /> 
     <DEF_DESCRIPTION /> 
     <DEF_JDD_SCENARIO /> 
     <PRIORITY /> 
     <REPAIR_TYPE /> 
     <BUYER /> 
     <WHEN_DISCOVERED /> 
     <HOW_MAL /> 
     <TCN /> 
     <PARTS_REQUIRED>T</PARTS_REQUIRED> 
     <PART /> 
     <MFG_MIN_QTY /> 
     <MFG_SETUP_TIME /> 
     <MFG_RUN_TIME /> 
     <MFG_LOT_PREFIX /> 
    </IFI005702>
    <IFI005703>
     <CUSTOMER_ID>SAP</CUSTOMER_ID> 
     <STRUCTURE_CODE>SUPERX</STRUCTURE_CODE> 
     <SUB_STRUCTURE_CODE /> 
     <POS /> 
     <PART /> 
     <REMARKS /> 
     <CREATED_USERID /> 
     <CREATED_DATETIME /> 
     <LAST_CHANGED_USERID /> 
     <LAST_CHANGED_DATETIME /> 
     <IFI00570301>
      <CUSTOMER_ID>SAP</CUSTOMER_ID> 
      <EFF_FROM>SX001</EFF_FROM> 
      <EFF_THRU>SX010</EFF_THRU> 
     </IFI00570301>
    </IFI005703>
   </IFI0057>
  </BODY>
 </INTERFACE>
</INTERFACES>

Also this is all the data stored in one field of the XML_DATA column. Each field is similar to this other than some tags are populated and some are not depending on what was filled out.

Lastly, I do not own the database, I'm an end user and don't have control over what I get to use (that might change over time)... I should be happy I got PL/SQL and Teradata SQL to poke around with, otherwise I'm SOL. Funny because we're a huge corporation yet there is no budget for support. I can't add tables or edit the data unless I use the interface we have which does not tell us what we need to know.

I hope this clears up any confusion.

[Updated on: Thu, 17 March 2011 15:18]

Report message to a moderator

Re: Problem querying XML in CLOB column [message #500120 is a reply to message #500112]

Thu, 17 March 2011 16:13

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> create table t (trans_sequence integer, xml_data clob);

Table created.

SQL> insert into t values (8191602, 
  2  '<INTERFACES>
  3   <INTERFACE>
  4    <HEADER>
  5     <INTERFACE_NAME>CREATE_UPDATE_PLAN_ACTIVITY</INTERFACE_NAME> 
  6     <EXTERNAL_APP_NAME>SILVER</EXTERNAL_APP_NAME> 
  7     <EXTERNAL_APP_ID>INTFCE</EXTERNAL_APP_ID> 
  8    </HEADER>
  9    <BODY>
 10     <IFI0057>
 11      <CUSTOMER_ID>SAP</CUSTOMER_ID> 
 12      <ACTIVITY_CODE>2201-020742</ACTIVITY_CODE> 
 13      <CODE_DESCRIPTION>BRACKET INSTALL</CODE_DESCRIPTION> 
 14      <ACTIVITY_TYPE>Z</ACTIVITY_TYPE> 
 15      <ACTIVITY_GROUP>1110</ACTIVITY_GROUP> 
 16      <SHORT_DESCRIPTION>BRAC</SHORT_DESCRIPTION> 
 17      <LAST_CHG_DATETIME>20110309</LAST_CHG_DATETIME> 
 18      <STATUS>COMPLETE</STATUS> 
 19      <EST_MATERIAL_COST /> 
 20      <EST_LABOR_HOURS>8</EST_LABOR_HOURS> 
 21      <EST_DAYS /> 
 22      <USER_REF1>5</USER_REF1> 
 23      <USER_REF2>CD-11001-007</USER_REF2> 
 24      <USER_REF3 /> 
 25      <USER_REF4 /> 
 26      <USER_REF5 /> 
 27      <USER_REF6 /> 
 28      <USER_REF7 /> 
 29      <USER_REF8 /> 
 30      <PLAN_TYPE>INSTALL</PLAN_TYPE> 
 31      <ALT_PLAN /> 
 32      <MODEL>SUPERX</MODEL> 
 33      <DEPARTMENT>010ZD</DEPARTMENT> 
 34      <WBS_CLIN>1.1.2</WBS_CLIN> 
 35      <IFI005701>
 36       <CUSTOMER_ID>SAP</CUSTOMER_ID> 
 37       <ACTIVITY_CODE /> 
 38       <MASTER_FORM_CODE /> 
 39       <MASTER_FORM_TYPE>WO</MASTER_FORM_TYPE> 
 40      </IFI005701>
 41      <IFI005702>
 42       <CUSTOMER_ID>SAP</CUSTOMER_ID> 
 43       <DEFAULT_ORDER>2201-020742</DEFAULT_ORDER> 
 44       <DEF_TYPE /> 
 45       <DEF_DESCRIPTION /> 
 46       <DEF_JDD_SCENARIO /> 
 47       <PRIORITY /> 
 48       <REPAIR_TYPE /> 
 49       <BUYER /> 
 50       <WHEN_DISCOVERED /> 
 51       <HOW_MAL /> 
 52       <TCN /> 
 53       <PARTS_REQUIRED>T</PARTS_REQUIRED> 
 54       <PART /> 
 55       <MFG_MIN_QTY /> 
 56       <MFG_SETUP_TIME /> 
 57       <MFG_RUN_TIME /> 
 58       <MFG_LOT_PREFIX /> 
 59      </IFI005702>
 60      <IFI005703>
 61       <CUSTOMER_ID>SAP</CUSTOMER_ID> 
 62       <STRUCTURE_CODE>SUPERX</STRUCTURE_CODE> 
 63       <SUB_STRUCTURE_CODE /> 
 64       <POS /> 
 65       <PART /> 
 66       <REMARKS /> 
 67       <CREATED_USERID /> 
 68       <CREATED_DATETIME /> 
 69       <LAST_CHANGED_USERID /> 
 70       <LAST_CHANGED_DATETIME /> 
 71       <IFI00570301>
 72        <CUSTOMER_ID>SAP</CUSTOMER_ID> 
 73        <EFF_FROM>SX001</EFF_FROM> 
 74        <EFF_THRU>SX010</EFF_THRU> 
 75       </IFI00570301>
 76      </IFI005703>
 77     </IFI0057>
 78    </BODY>
 79   </INTERFACE>
 80  </INTERFACES>');

1 row created.

SQL> commit;

Commit complete.

SQL> select trans_sequence
  2  from t, table(xmlsequence(extract(xmltype(xml_data),'//ACTIVITY_CODE'))) x
  3  where extractvalue(value(x),'//ACTIVITY_CODE') = '2201-020742'
  4  /
TRANS_SEQUENCE
--------------
       8191602

1 row selected.

Regards
Michel

Report message to a moderator

Re: Problem querying XML in CLOB column [message #500240 is a reply to message #500120]

Fri, 18 March 2011 09:50

aileron
Messages: 3
Registered: March 2011

Junior Member

Didn't work

SQL> SELECT TRANS_SEQUENCE
  2  FROM HMS_XML_TRANSFER, TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(XML_DATA),'//ACTIVITY_CODE'))) x
  3  WHERE EXTRACTVALUE(VALUE(x), '//ACTIVITY_CODE') = '2201-020742';
FROM HMS_XML_TRANSFER, TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(XML_DATA),'//ACTIVITY_CODE'))) x
                                                 *
ERROR at line 2:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00241: entity reference is not well formed
Error at line 21
ORA-06512: at "SYS.XMLTYPE", line 254
ORA-06512: at line 1

This is the most common message I get... I'm starting to wonder if there is something about the version of oracle that is the problem. There doesn't appear to be any odd characters like an "&" in the XML unless its hidden as an escape character or something. Also going over the XML it appears to be well formed. I haven't found anything out of the ordinary. But alas, I'm not an xml guru.

This is real frustrating, I'm really at wits end on this... Thanks for trying to help.

Report message to a moderator

Re: Problem querying XML in CLOB column [message #500241 is a reply to message #500240]

Fri, 18 March 2011 09:59

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

This is the most common message I get... I'm starting to wonder if there is something about the version of oracle that is the problem.

I bet this is the case.
If you cannot not reproduce the test case I posted then this is actually the case.
As I said, stay away from version 9.0, Oracle throwed it away just after 9.2 was released and never offered any extended support.

Regards
Michel

Report message to a moderator

Re: Problem querying XML in CLOB column [message #500404 is a reply to message #500241]

Sun, 20 March 2011 22:50

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

The fact that you get the error messages when performing a search that selects from all rows and that you do not get the error message when performing a search that has a filter condition that limits it to one row, indicates that although the xml data in the row that you are searching is well-formed, the data in some other row is not. Most likely there is an ampersand in some other row. If so, this can be solved simply by using replace. Please see the simplified reproduction and solution below, where I have entered one row without an ampersand and one row with an ampersand. One query produces the error stack that you are getting and the one that limits it to the row without the ampersand works. Then, adding replace, the original query works. If this does not help, then I suspect that there is something other than an ampersand that constitutes data that is not well-formed in one or more rows. You may be able to limit your search to ranges of records and such until you can figure out what the offending row(s) is/are and how to deal with them.

-- simplified reproduction of problem:

SCOTT@orcl_11gR2> CREATE TABLE hms_xml_transfer
  2    (trans_sequence	NUMBER (38),
  3  	xml_data	CLOB)
  4  /

Table created.

SCOTT@orcl_11gR2> SET DEFINE OFF
SCOTT@orcl_11gR2> INSERT INTO hms_xml_transfer VALUES (8191602,
  2  '<BODY>
  3  	<ACTIVITY_CODE>2201-020742</ACTIVITY_CODE>
  4  	<OTHER>test data</OTHER>
  5   </BODY>
  6  ')
  7  /

1 row created.

SCOTT@orcl_11gR2> INSERT INTO hms_xml_transfer VALUES (1234567,
  2  '<BODY>
  3  	<ACTIVITY_CODE>1234-567890</ACTIVITY_CODE>
  4  	<OTHER>test & data</OTHER>
  5   </BODY>
  6  ')
  7  /

1 row created.

SCOTT@orcl_11gR2> COMMIT
  2  /

Commit complete.

SCOTT@orcl_11gR2> SELECT TRANS_SEQUENCE
  2  FROM   HMS_XML_TRANSFER,
  3  	    TABLE
  4  	      (XMLSEQUENCE
  5  		(EXTRACT
  6  		  (XMLTYPE(XML_DATA),
  7  		   '//ACTIVITY_CODE'))) x
  8  WHERE  EXTRACTVALUE(VALUE(x), '//ACTIVITY_CODE') = '2201-020742'
  9  /
ERROR:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00242: invalid use of ampersand ('&') character (use &amp;)
Error at line 3
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1



no rows selected

SCOTT@orcl_11gR2> SELECT TRANS_SEQUENCE,
  2  	    EXTRACTVALUE
  3  	      (XMLTYPE (XML_DATA),
  4  	       '//ACTIVITY_CODE')
  5  FROM   HMS_XML_TRANSFER
  6  WHERE  TRANS_SEQUENCE = '8191602'
  7  /

TRANS_SEQUENCE
--------------
EXTRACTVALUE(XMLTYPE(XML_DATA),'//ACTIVITY_CODE')
--------------------------------------------------------------------------------
       8191602
2201-020742


1 row selected.

-- solution using replace:

SCOTT@orcl_11gR2> SELECT TRANS_SEQUENCE
  2  FROM   HMS_XML_TRANSFER,
  3  	    TABLE
  4  	      (XMLSEQUENCE
  5  		(EXTRACT
  6  		  (XMLTYPE(REPLACE (XML_DATA, '&', '&amp;')),
  7  		   '//ACTIVITY_CODE'))) x
  8  WHERE  EXTRACTVALUE(VALUE(x), '//ACTIVITY_CODE') = '2201-020742'
  9  /

TRANS_SEQUENCE
--------------
       8191602

1 row selected.

SCOTT@orcl_11gR2>

Report message to a moderator

Re: Problem querying XML in CLOB column [message #564321 is a reply to message #500082]

Wed, 22 August 2012 10:59

koteswar
Messages: 4
Registered: August 2012
Location: bangalore

Junior Member

Hi ,
CLOB data type is not supported in XML, you have to create a function for that and then call the function in sql statement.

thanks,
koteswar.

Report message to a moderator

Re: Problem querying XML in CLOB column [message #564339 is a reply to message #564321]

Wed, 22 August 2012 16:01

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

koteswar wrote on Wed, 22 August 2012 08:59

...CLOB data type is not supported in XML, you have to create a function for that and then call the function in sql statement....

If the clob contains valid xml, then you do not need to create a function, as there are plenty of Oracle built-in functions, as demonstrated in the previous answers in this thread.

Report message to a moderator

Previous Topic:	Tnsnames doubt
Next Topic:	error on jsf

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 09:50:57 CST 2025