PL SQL Tutorial
What a beautiful language it is !!!! I have around of 9 years of experience in IT industry and i just love Oracle. Very easy to learn and to work in Pl SQL So I am sharing a tip to hold on PL SQL ,it is 'Practice','Practice' and 'practice' this is the only one thing that need to understand that practice make a professional perfect. Second, Break your longer query into small chunks. Third, Uses of sub-queries .trust me it increase the performance. Fourth,never underestimate the power of indexing. Fifth,uses of hints but it works only if tables are analysed and updated stats. Sixth,uses of with clause. Seventh,proper use of indexing. Eight, when to use dynamic query, when not!!!!