This Session will provide the 12c SQL and PL/SQL New Features with the examples. We will also highlight on Best Practices. These Features are really helpful to Developers. We will be sharing Possible Errors and Solutions wherever possible. As part of 12c SQL, we will be covering "Identity Columns", "Extended String Datatypes", "Top N queries using FETCH FIRST and OFFSET", "Invisible Columns", "Handling default columns". As part of 12c PL/SQL, we will be covering "Using %ROWTYPE with Invisible Columns", "FETCH FIRST Clause and BULK COLLECT", "UTL_CALLSTACK Package", etc.
Sailaja Pasupuleti is a Principal Instructor with Oracle University. She has 12+ Years I.T. experience in Oracle Technologies. She currently handles courses for SQL Tuning, PL/SQL, Database Administration, Performance Tuning, RAC, Data Guard, Exadata, EDQ, etc. Prior to Oracle she worked with Satyam Computers. She has been involved in reviewing the PL/SQL Quizes in the Website http://www.plsqlchallenge.com (Site Owner: Steven Feuerstein). She is an active member of the AIOUG (All India Oracle Users Group) and handled session on "PL/SQL Programming with Collections" during the AIOUG SANGAM'12.