{"id":302,"date":"2008-12-12T21:10:30","date_gmt":"2008-12-12T20:10:30","guid":{"rendered":"http:\/\/bar-solutions.com\/wordpress\/?p=302"},"modified":"2008-12-12T21:14:00","modified_gmt":"2008-12-12T20:14:00","slug":"code-refactoring","status":"publish","type":"post","link":"https:\/\/blog.bar-solutions.com\/?p=302","title":{"rendered":"Code refactoring…"},"content":{"rendered":"

Steven Feuerstein<\/a> wrote an entry<\/a> on his Toadworld<\/a> blog where he checks the refactoring capabilities of SQL-Developer. <\/p>\n

I am trying the same things in PL\/SQL Developer<\/a> to see if this does do the trick.<\/p>\n

<\/p>\n

First of all, a different couple of options are presented to you when you wrong click (or right click) a piece of highlighted code, depending on what you selected.<\/p>\n

\"refactoring_menu\"<\/a><\/p>\n

Let\u2019s take the following code as our starting point:<\/p>\n

\n
\n
create<\/span> or<\/span> replace procedure<\/span> use_cursor (<\/pre>\n
   security_level_in in<\/span>     pls_integer<\/pre>\n
,  cursor_out        in<\/span> out<\/span> number<\/pre>\n
)<\/pre>\n
authid definer<\/pre>\n
is<\/span><\/pre>\n
begin<\/span><\/pre>\n
   cursor_out := dbms_sql.open_cursor(security_level_in);<\/pre>\n
   <\/pre>\n
   dbms_sql.parse ( cursor_out<\/pre>\n
                  , 'select count(*) from all_source'<\/span><\/pre>\n
                  , dbms_sql.native<\/pre>\n
                  );<\/pre>\n
end<\/span>;<\/pre>\n<\/p><\/div>\n<\/div>\n