Parallel 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 DetailsCategory: SQL
Pipelined 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