Let us suppose we have a table T_APHA_NUMERIC which consists alphanumeric column as shown below APHA_NUMERIC CDNTK1V0103H 123ABC45NJDK ABC12345...
Materialized Views Stores results not queries Requires Physical memory No auto updates Execution time is less Views Stores queries not...
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...
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...
Introduction This article discusses about the Two Dimensional To Three Dimensional conversion and vice versa in c++ The following program...
I will explain how to create a directory in linux using a c++ program. The program to create a directory is as follows: #include<iostream.h>...
Learn to use code block when you have code snippets in posts Hello shabbir i don't know what is code snippets and code block .Please can u...
If two process are there and one shared memory is there. One wants to write the data and another wants to read the data to the shared memory. I...
I am trying the following program to send a structure but i am not able to get the result what i want . Can any one tell me what changes i have to...
I have a string 13/06/07 but i have to convert it into integer and 13 , 06 and 07 has to be separated in c++.
Suppose i have a file in which i have strings and integers I want read that file and wants to store in an array. My problem is how to...
I tried two methods for this and it worked. First Method : #include<stdio.h> void fun(int *a,int col , int row) { int i,j;...
Separate names with a comma.
