Let us suppose we have a table T_APHA_NUMERIC which consists alphanumeric column as shown below APHA_NUMERIC CDNTK1V0103H 123ABC45NJDK ABC12345...
After logging in i was not able to see. Reply button also not working in chrome. I am replying from IE.
Materialized Views Stores results not queries Requires Physical memory No auto updates Execution time is less Views Stores queries not...
Hi Shabbir, I am not able to see Subscribe,Post New Tread and Submit New Article in Chrome but able to see in IE.
Shabbir, The Design looks great and i like it very much.
Hi Shabbir , I like very much new face lift of G4E.
In below articles I have used both group by and also partition by Difference between rank, dense_rank and row_number function in Oracle...
We will try to understand the difference by looking into below examples. Let us suppose we have a table called rnk_tbl with below data...
Finding Count of Outgoing and Incoming calls from a Caller Log table in Oracle has not covered total scenario and the query is not universal. Let...
In day to day life we all use mobile phones and make outgoing and incoming calls. Normally our each call will be stored in the caller log in...
Now let us try to do same in Unix as we have discussed in the following Article - Splitting String Using Delimiter in Oracle In Unix it is pretty...
Let us suppose we have a string like 'GO 4 EXPERT|99999|20130101|20131231' and we have a requirement to split the string based on delimiter....
Before going to unterstand abot Oracle gather stats we need to understand below things 1. Optimizer 2. Explain Plan 3. dba_tables 1....
I am having a File format as mentioned below Employee id|Name|Languages 12345|ABC|02|English|Hindi 4567|DEF|03|Engligh|Hindi|Urdu the 02 and 03...
Hi gaurav i have written another method for printing the date check it. u can implement this program in c also.First read whole article and...
Another method for printing the date from starting to ending This method is useful if u r dealing with dates.If u want to do some operation...
Printing the date from starting date to ending date The program takes the starting date and ending date as inputs and prints the dates in...
In while use array to store This , a , sample and string . And after loop use strcat() function to store This and sample in a string and same for...
ur condition is wrong . To print b and c ur condition should be a>=400 or a>400 or a>=500.
Nice article
Separate names with a comma.