admin – Page 6 – SWKB.NET

Java: XPath: Read series of attributes from xml files

Post author:admin
Post published:January 22, 2014
Post category:Java: How To Examples
Post comments:0 Comments

The following piece of code is an example of extraction of specific attribute from an xml file.The xml looks like this:<?xml version="1.0" ?><xliff xmlns="urn:oasis:names:tc:xliff:document:1.2" xmlns:fn="http://www.w3.org/2005/02/xpath-functions" xmlns:xft-xliff="http://www.xfa.org/schema/xfa-xliff/1.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.1" xsi:schemaLocation="urn:oasis:names:tc:xliff:document:1.2 xliff-core-1.2-transitional.xsd"><file…

Oracle PL/SQL: Compare strings algorythm

Post author:admin
Post published:January 22, 2014
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

The following piece of code, reads a list of problematic strings and tries to match them using a list of valid codes.In order to get the best match there is…

Oracle PL/SQL: Custom Exceptions

Post author:admin
Post published:January 22, 2014
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

Here is a piece of code, which shows the structure of user defined exception:declare exc_invalid_request_id EXCEPTION;... IF l_accepted_request > 0 THEN RAISE exc_invalid_request; END IF;... EXCEPTION WHEN exc_invalid_request THEN

Java: XPath: Extract part of xml

Post author:admin
Post published:December 15, 2013
Post category:Java: How To Examples
Post comments:0 Comments

Please, view the following related article:Oracle DB: XPath: Extract part of xml

Oracle DB: XPath: Extract part of xml

Post author:admin
Post published:December 15, 2013
Post category:Oracle DB: How To Examples
Post comments:0 Comments

The following examples are applied on Oracle DB, but they can be used also with another language, e.g. Java.The last examples illustrate in particular SOAP envelope xml extraction.Simple Examles:select xmltype('<a><b><return>vag</return></b></a>').extract('/a/b/text()').getstringval()…

Oracle PL/SQL: Create CLOB / Read CLOB

Post author:admin
Post published:December 10, 2013
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

In the following example the procedure create_csv creates a CLOB, which is then printed out.CLOB can be printed out, either simply, using DBMS_OUTPUT.PUT_LINE, or with the procedure print_clob_out, which is…

Oracle PL/SQL: Time Difference

Post author:admin
Post published:November 21, 2013
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

The following script show how to calculate the time difference between 2 execution points:declare thediff number; TIME1 timestamp; TIME2 timestamp; i number;begin TIME1 := SYSDATE; for i in 1..1000000000 loop …

Oracle PL/SQL: Pagination methods

Post author:admin
Post published:November 17, 2013
Post category:Oracle PL/SQL: How To Examples
Post comments:0 Comments

The official way to achieve pagination in Oracle DB is not very elegant and very very slow. The reasons why it is slow are 2:The order by command must be…

Oracle DB: Shrink space taken by table

Post author:admin
Post published:November 16, 2013
Post category:Oracle DB: How To Examples
Post comments:0 Comments

You can execute the following statements in the given order in order to shrink the data taken by your tables:alter table APPS.XXACCOUNT_BALANCES enable row movement;alter table APPS.XXACCOUNT_BALANCES shrink space COMPACT; …

Oracle DB: Gather statistics – Show statistics

Post author:admin
Post published:November 7, 2013
Post category:Oracle DB: How To Examples
Post comments:0 Comments

Gather schema statsistics:exec dbms_stats.gather_schema_stats( - ownname => 'SCOTT', - options => 'GATHER AUTO' );Show schema stats:select * from DBA_IND_STATISTICS WHERE OWNER='SCOTT'select * from DBA_TAB_STATISTICS WHERE OWNER='SCOTT'select * from DBA_TAB_COL_STATISTICS WHERE…