admin – Page 5 – SWKB.NET

XPath: Oracle DB: Extract part of xml

Post author:admin
Post published:May 27, 2014
Post category:Oracle
Post comments:0 Comments

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

VirtualBox: Expand fixed disk

Post author:admin
Post published:May 5, 2014
Post category:Various
Post comments:0 Comments

Here is how to expand the space of a fixed disk in VirtualBox:First, the disk should be cloned with the flag --variant Standard, so to be converted into dynamic. Then…

Oracle DB: Locked objects

Post author:admin
Post published:May 4, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

Find out which objects are locked using the following query: select substr(a.os_user_name,1,15) "OS User", substr(a.oracle_username,1,8) "DB User", substr(b.owner,1,8) "Schema", substr(b.object_name,1,20) "Object Name", substr(b.object_type,1,10) "Type", substr(c.segment_name,1,15) "RBS", substr(d.used_urec,1,12) "# of Records", …

Oracle DB: Uncommited transactions

Post author:admin
Post published:May 4, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

You can find the number of uncommited transactions using the following query:SELECT ROWS_PROCESSED,sql_textFROM v$sqlareaWHERE (address, hash_value) IN(SELECT sql_address, sql_hash_valueFROM v$sessionWHERE sid in (select sid from v$session where schemaname='VAG'))or using v$transaction…

WebLogic Server 12c – ADF: Preparation for ADF on Windows

Post author:admin
Post published:May 1, 2014
Post category:WebLogic
Post comments:0 Comments

Here are the steps needed to prepare the Weblogic Server 12c for running ADF applications on Windows:Prerequisite: Use Java Standard Edition JDK installed on a directory, which does not have…

Oracle DB: Add/Drop/Rename objects

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

Some sample commands for Add/Drop/Rename objects:--Dropping the primary key:ALTER TABLE "VAG"."TEST_TABLE" drop primary key;drop index "VAG"."TEST_TABLE_PK";--Adding primary key:CREATE UNIQUE INDEX "VAG"."TEST_TABLE_PK" ON "VAG"."TEST_TABLE" ("TEST_TABLE_ID");ALTER TABLE "VAG"."TEST_TABLE" ADD CONSTRAINT "TEST_TABLE_PK" PRIMARY…

Oracle PL/SQL: Autonomous Transaction for logging

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

Here is an example how to use autonomous_transaction for logging purposes.In case of rollback only the main transaction is affected.declare l_categories_count varchar2(100); process_error Exception; procedure log(p_message varchar2) is …

Oracle DB: Extract DDL without storage specifications

Post author:admin
Post published:April 14, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

For exporting the DDL of data objects without the storage specifications, this is what we should do:EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);select DBMS_METADATA.GET_DDL('TABLE','PROJECTS') from DUAL;EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'DEFAULT');

Oracle DB: Get BLOB field size in sql query

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

This is how to get the size of a BLOB in SQL query:select file_id, doc_xml, dbms_lob.getlength(doc_xml) from my_files order by dbms_lob.getlength(doc_xml) desc

Java: Ping application

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

Here is a code to call ping command on windows using java. The question would be, why not to ping directly from ms-dos window? :)The answer is because this application…