Kirtan Desai

In Oracle/PLSQL, the NVL function allows you to substitute a value when a null value is encountered. The syntax for the NVL function is: NVL(a_value, replace_it_with ) a_value is the string to test for a null value. replace_it_with is the value returned if string1 is null. Examples, select NVL(product_descr, product_name) from products; This statement would [...]

This is the basic explanation of what SQL/XML functions provide in Oracle (since 9iR2) Database as per SQL 2003 standards. XMLElement takes an element name, an optional collection of attributes for the element, and arguments that make up the element’s content and returns an instance of type XMLType. XMLForest converts each of its argument parameters to XML, [...]

info AT kirtandesai DOT com  

I had to delete my post on shell scripting that referred to a webpage on oracle.com. I was doing some updates to post formats and such and noticed that the link on my post was not valid (alive) anymore. Sorry for the inconvinience. Here is what I had in the post. Shell Scripting For DBAs [...]

Top-N queries provide a method for limiting the number of rows returned from sets (mostly ordered) of data. NOTE: Oracle does not guarantee that it will return the result of an SQL statement in the order the data was inserted into the table(s). Only way of achieving that is to explicitly uses the ORDER BY clause. Let’s see. [...]

Query to find oracle version details on your system. SQL> select banner from v$version; BANNER —————————————————————- Oracle9i Enterprise Edition Release 9.2.0.1.0 – Production PL/SQL Release 9.2.0.1.0 – Production CORE    9.2.0.1.0       Production TNS for 32-bit Windows: Version 9.2.0.1.0 – Production NLSRTL Version 9.2.0.1.0 – Production

All copyrights, trademarks and service marks are hereby acknowleged. Any third-party trademarks are hereby acknowledged. All comments and opinions expressed by me are my own and not those of my employers. All comments and opinions expressed by visitors/members are their own. This site has no association with anyone and any advice, comments on products or [...]

This is a collection of basic information about Using Oracle PL/SQL. The best way to learn PL/SQL is to either read the Oracle Documentation or buy(and read) books on the subject. ‘Practise’ has not stopped making a man perfect. Basic Structure of PL/SQL PL/SQL stands for “Procedural Language extension to the SQL”. SQL is the [...]

Here are my suggestions for someone who wants to start using and learning about Informatica Products. Join http://my.informatica.com Here, you will find all the documentation you need on all Informatica products. They also have a section called Knowledge Base where they log recommended solutions. You can browse through these solutions to find out how Informatica [...]