[PL/SQL] HELP Needed On MUTATING TABLE ERROR Concpets

2013-02-21 Thread Lokesh ND
Hi All, Greetings... I am new to this Group , I am learning more things from this group , i thank all of them who are sharing there knowledge and experience in this group . I would like to ask all the senior's Member's in the group i am not able to understand Mutating table Error

Re: [PL/SQL] Search by last name procedure design

2013-02-21 Thread عبادي الشمراني
بتاريخ الخميس، ٢١ فبراير، ٢٠١٣، جاء من ddf orat...@msn.com: On Wednesday, February 20, 2013 12:50:09 PM UTC-7, Ninja Li wrote: Thanks for your replay. There is b-tree index on last_name, Partition is actually on a different column bill_num, which is also used for search. However in this

Re: [PL/SQL] Re: Expression in PL/SQL block

2013-02-21 Thread faisal khan
in that case it will be fine On Thu, Feb 21, 2013 at 1:03 AM, ddf orat...@msn.com wrote: On Tuesday, February 19, 2013 7:13:42 PM UTC-7, sidd wrote: u cannot use greatest function with null parameter, it will return null only On Wed, Feb 20, 2013 at 3:16 AM, Gayathri gd0...@gmail.com