Naveen Velu

Use the following command to find the cpu details. [naveenVelu@NaveenVelu ~]$ lscpu

To Change the Oracle User / Schema Password use the following query. ALTER USER YourUser IDENTIFIED BY YourPassword; ALTER USER YourUser ACCOUNT UNLOCK;

To list all the tables in Oracle 11g / 12c Method 1: SELECT TABLE_NAME FROM ALL_TABLES; Method 2: if you have dba privileges use the following query SELECT TABLE_NAME FROM DBA_TABLES; To list all tables in schema Step 1: Connect to the corresponding schema Step 2: SELECT TABLE_NAME FROM USER_TABLES; To list all the table in Oracle 11g / 12c with a particular column Method 1: SELECT TABLE_NAME FROM ALL_TAB_COLUMN WHERE UPPER(COLUMN_NAME)=UPPER('COLUMN_NAME'); Method 2: if you have dba privileges use the following query SELECT TABLE_NAME FROM DBA_TAB_COLUMN WHERE UPPER(COLUMN_NAME)=UPPER('COLUMN_NAME'); To list all tables in schema with a particular column Step 1: Connect to the corresponding schema Step 2: SELECT TABLE_NAME FROM USER_TAB_COLUMN WHERE UPPER(COLUMN_NAME)=UPPER('COLUMN_NAME');

Command to find the Symbolic l ink recursively in the current directory find . -maxdepth 1 -type l -ls

I was pleasantly surprised to see the when my name has been spelled during the Awarding ceremony at  first year Anniversary of DiligentSquad Technologies but  I'm glad for this because this is my very first career award and I am pretty excited and proud to receive it.An unforgettable day (August 1st) in my life.Now I have to find the right place to display it at home.This award shows me that I need to keep working.Thank you, Diligent Squad. Also special thanks to Inba.