Questions by usmita

This Question is not yet answered!

•   Need to find the list of employees who is from finance department having 1200 pincode
•   Load a file in Oracle in chunks of 100 MB files
•   Load different data files in single target table
•   Print position of char
•   Error while inserting records into table
•   Display your name 10 times in PL/SQL
•   What will be the output?
•   Sorting alphanumeric values
•   SCD insert, update and link data
•   Correlated sub query

•   Rdbms
•   Drop a table and its child tables from a database using procedure
•   Rank transformation type and range by partition
•   Find 2 highest salary from each depart who have completed 5 years in org.
•   Update a table using multiple join conditions
•   Find destination field
•   What is calculating context?
•   Automation testing
•   Game of jack straws
•   2nd highest record from each group basis on manager id including manager itself as well (null group)