Raghavendra Boralli
Member²
Hi,
1.PL/SQL Beautifier formats the source code only if the stored procedure/package being opened is in edit mode. Why such restriction?Some of the famous source code editors will format the code even in view mode. Can we have that feature in PL/SQL developer next version?
2. FOR UPDATE/ ROWID
To perform any DML operations on table using select statement,we have to append the FOR UPDATE clause at the end of each SQL statement or ROWID has to be included in the column list. Insted a button can be provided to indicate whether the result sets has to be updated or not.
If that button is pressed as "ON" then the select statements executed in that session would be default considerd as "FOR UPDATE" satement. Because its time consuming for each and every satement that we execute should have FOR UPDATE at the end.
Can we have this feature in next release?
Thanks
1.PL/SQL Beautifier formats the source code only if the stored procedure/package being opened is in edit mode. Why such restriction?Some of the famous source code editors will format the code even in view mode. Can we have that feature in PL/SQL developer next version?
2. FOR UPDATE/ ROWID
To perform any DML operations on table using select statement,we have to append the FOR UPDATE clause at the end of each SQL statement or ROWID has to be included in the column list. Insted a button can be provided to indicate whether the result sets has to be updated or not.
If that button is pressed as "ON" then the select statements executed in that session would be default considerd as "FOR UPDATE" satement. Because its time consuming for each and every satement that we execute should have FOR UPDATE at the end.
Can we have this feature in next release?
Thanks
