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