Pivot and Unpivot Operators in Oracle 11g
PIVOT In this article you will learn how to use PIVOT and UNPIVOT operators. Basically, pivot operator allow you to transpose rows into columns. Prior to 11g, it […]
More DetailsCategory: SQL
ORA-22859 invalid modification of columns
When you try to convert datatype CLOB to VARCHAR2, you get the ORA-22859 invalid modification of columns error even if the column is empty. In order to overcome […]
More DetailsParallel Enabled Pipelined Table Functions
In the previous article, I mentioned about pipelined table functions. In this article, I am going to talk about parallel feature of pipelined table functions. At least one […]
More DetailsPipelined Table Functions
Table functions are used in FROM clause of a query as if it were a regular table that return PL/SQL collections. Returning large size of collections can be […]
More DetailsXPath / XQuery / SQL
In brief, I will compare the equivalence of SQL, XQuery and XPATH. The following XML feed is used for this purpose. Oracle 11g is used. Now, I want […]
More DetailsRegular Expression
You can use the following character classes for your regex pattern. Character Class Description [:alnum:] Alphanumeric characters [:alpha:] Alphabetic characters [:blank:] Blank Space Characters [:cntrl:] Control characters (nonprinting) […]
More DetailsOracle TRANSLATE function
Oracle TRANSLATE(expression, from_string, to_string) function can replace all characters from from_string to to_string by its corresponding character. Also, the important thing is replacement is done by the order […]
More Details