SQL ,PLSQL , Unix

Say you are given a task to manipulate a set of 10 million records from a couple of tables. What would you do? Sit and think???!!!! See if the following helps you.. Replicate the tables data into temporary tables Create indexes on the columns you want to manipulate the data Write your query.. Dont ask me what language you are talking!!!! Look at the examples Select count(1) from hugeTable1;--7999900 records Select count(1) from hugeTable2; --9893990 Create table tmp1 as Select * from hugeTable1 where 1=2; insert /*+append*/ into tmp1 select * from hugeTable1; Create table tmp2 as Select * from hugeTable2 Where 1=2; insert /*+append*/ into tmp2 select * from hugeTable2; create index indTmp1 on tmp1(column1,column2); create index indTmp2 on tmp2(column1,column2); Select * from tmp1,tmp2 where tmp1.column1=tmp2.column1 and           tmp1.column2=tmp2.column2;     Should you face any issues, please write to me ( s...

wc - command is used to list all files in  a directory with its records count Prompt>$ wc -l *.txt 10  file1.txt 93  sampleFile.txt 199333 billingData.txt 65  loadData.txt Prompt>$

This was asked in a meeting of following people and the answers are amazing... An Analyst replied  - I need a month time to prepare analysis whether it is possible or the way possible Technical architect replied  -It is not impossible but involves lots of work. Team Lead interrupted  - Google it , you should be able to find it One in the team suggested - It will cause performance issues Developer maintained a silence until everyone calmed down and said.. - Lets make use of data dictionaries - Find out Varchar fields and construct a query - Lets list objects that has the data searched - We will then narrow down our search - It is not time-consuming job yet not a quick one Analyst quickly replied - We know that, but it is not right to do as it will cause unnecessary issues Team Lead                     - Were you not supposed to complete the other assignment? You concentrate on that!!! Technical Archi...

1. file           - Will list the file encoding details           - Read man page for more details 2. pdftohtml         - Utility to convert pdf file to html format 3. iconv -f -t          - to change the file encoding from one format to another  Ex:       iconv -f UTF-16 -t ASCII filename.txt        - Read man page for more supported encoding formats 4.  ls -R | grep -i * *       - List files in subdirectories 5.  last       - To see the list of users who were connected to the system       - It gives you the list with the details logon time, logon ip, user id etc.,