Today while working on my project I suddenly got the requirement of getting all the Table Name which contains the particular Column Name. At that time i thought its not possible, but oracle has features of that also. You can get the details of all the Tables including the Column Name.
Just use “ALL_TAB_COLUMNS”.
This particular table [...]
Archive for the ‘Oracle’ Category
Oracle Gyan…
Posted in Oracle on February 19, 2009 | Leave a Comment »
Oracle : LNNVL Function
Posted in Oracle on February 12, 2009 | Leave a Comment »
Recently i got a very weird CR in my project. In my project we are generating dynamic query for update and insert and that to we will generate it from the datatable column name. Now the problem was, for some column the value can be NULL so in the update statement we can’t write as [...]
Oracle : Analytic Function
Posted in Oracle, Technical on November 24, 2008 | Leave a Comment »
Basically this post is meant for PL/SQL coders who might not be using analytic function (like me) due to very complex syntax. Personally i found analytic function to be very useful and recently i used it in my project since there was requirement which can be fulfilled only Analytic Function. So i can say my [...]
Oracle : Translate Function
Posted in Oracle on November 20, 2008 | Leave a Comment »
Most of them might be knowing Translate Function in Oracle.The TRANSLATE function allows you to replace characters in an expression that appear in a from string to their corresponding character in the to string. For Example :
select translate(‘Rishi*Daftary’,’*’,’#’) from dual;
Above query will replace all the occurence of * to #. But the main problem here [...]
