These are 41 Most Useful SSH Putty commands to help you manage the VPS (Virtual Private server) or Dedicated Server. These putty commands should help you in daily work on the server. I have included SSH Putty commands for all major Linux distribution like Cent-OS ,Ubuntu (1)How to connect to Server using putty Download Putty here […]
Online Oracle Apps DBA Training Course
Here in this post, I will provide online oracle apps dba training. This post has enough material for the beginner to start learning oracle apps dba and start dealing with small task in it. I have also enough link on my site related to oracle apps dba What is Oracle EBSOracle’s E-Business Suite (also known […]
Oracle Interview questions
This article contains Top 49 Oracle Interview questions : Basics , Oracle SQL asked in various interview. I hope it should help in interviews Oracle Interview questions : Basics , Oracle SQL Question 1. What is a table Cluster ?Answer: Table Cluster is a group of related tables that share common columns are store related […]
Gathering Statistics in Release 11i and R12
In order to use Cost Based Optimizer effectively, the statistics must be current. Fortunately, Oracle has provided some scripts and concurrent programs to make this administrative task easier. FND_STATS is a PL/SQL package for the Applications that has numerous functions that will assist in this administrative task. This package can be invoked either from a […]
how to find indexes on a table in oracle
It is very common that you want to Find indexes status and assigned columns for a oracle tableAnd also you sometime want to know the columns which are assigned to the indexes.Following views would be helpful in these cases and to find indexes on a table in oracle dba_ind_columns all_ind_columns Query to Find the indexes […]
Oracle NULLIF() function
This SQL tutorial provides explanations, examples for NULLIF function in Oracle NULLIF function is very useful function .It compare two values and return null if the values are same , else return the first value expr1 : it is the source values or expression which is going to be compared with expr2expr2 : It is […]