When Others Then Null

Friday, 27 October 2017

Parent Child Report - SQL Developer

›
To create a parent child report in SQL Developer Click on the View Menu and then Reports. Once reports is shown right click on User Def...
Saturday, 21 October 2017

Drill Down Report - SQL Developer

›
In SQL Developer you can link one oracle report to another creating a drill down from the first report to the second. To do this we create...
1 comment:
Friday, 9 October 2015

ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind

›
The example below is raising a ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind DECLARE TYPE rec1_typ IS RE...
1 comment:
Thursday, 8 October 2015

Oracle, accessing collections in SQL

›
In Oracle it is possible to access collections within SQL statements. With the following collection: CREATE TYPE region_tab AS TAB...
Monday, 21 September 2015

ora-00904 xml invalid identifier

›
If you have a XML column as part of a table, for example: DESC tab_with_xml_column Name ...
Tuesday, 22 January 2013

Validate XML against an XSD using JDeveloper

›
Validating xml against an xsd can be achieved thorough JDeveloper, (which is available as a free  download ). As an example, if we...
Monday, 7 January 2013

VB .Net, Creating Hello World Example

›
In this blog entry we are going to create a form in VB .Net.  The user will be able to run the form and enter their name in a text box...
›
Home
View web version
Powered by Blogger.