PLSQL



	cursor exception

	Stored Procedure , Function and Package to implement business logics

	created trigger

	

	Supplied Packages (UTL_FILE | DBMS_PROFILER |  ...)



	Report generation using UTL_FILE

	Bulk Collect 

	Dynamic sql

	Ref Cursor 



	Performance Tuning



Interview Process

	Resume 
		Contact Details
		Objective
		Professional Summary

					Exep 5+ | SW Dev Lifecycle 
					Dev / L1 Production Support 
					schema objects : table, view, Mview, seq , synonyms, index, types, directories....
					concepts : joins, sub queries, analytical functions , pseudocolumns...
					Statements : DDL , DML , DCL and TCL
					Written complex queries 
					loaded data by using sqlldr
					with clause, ROLLUP, CUBE, GTT....
					concepts : cursor and Exception
					written Stored Procedure, function and package to implement business logic.
					generated reports using UTL_FILE
					collection (index-by-table, nested-table and varray)
					loaded bulk data by using Bulk collect, bulk bind(FORALL) and handled Exception in that
					Dynamic sql 
					XMLGEN

		Work Experience 
		Tools Used
		Project
	Screening Call Content 
	Upload