Purpose: Sorts characters by using string of bytes. It can be use both as a comparison and sorting parlance....

Purpose: Sorts characters by using string of bytes. It can be use both as a comparison and sorting parlance. Syntax: NLSSORT(Sort_Column, NLS_PARAM) Where, Sort_Column => Column to sort NLS_PARAM => It takes the form of NLS_SORT = sort wher...

...

...

...

...

In Oracle, it is possible to split the record based on the columns and to insert them into multiple tables at the same time. Consider the below case where we have the tblEmployee as our base table...

Select * From tblEmployee; EMPID EMPNAME SALARY BELONGSTO DEPTID ---------- -------------------------------------------------- ---------- ---------- ---------- 1 Deepak Kumar Goyal...

You can go thru [ this ][1] article. Alternatively we can achieve this by creating our own via CLR approach/Table Types / CTE's etc. [1]: http://www.sommarskog.se/arrays-in-sql.html...

You can go thru [ this ][1] article. Alternatively we can achieve this by creating our own via CLR approach/Table Types / CTE's etc. [1]: http://www.sommarskog.se/arrays-in-sql.html...