Showing posts with label toad. Show all posts
Showing posts with label toad. Show all posts
Friday, 2 February 2018

How to debug code in Toad?

›
e.g. Toad for Oracle -> Database -> Schema Browser -> Click HR -> Click Procedures -> Double click to "PROC_EXEC" ...

How to grap and drop table columns in Toad?

›
e.g. Toad for Oracle -> Type HR.EMPLOYEES then Press F4 in Editor -> Select desired columns by CTRL key-> Drag and drop to Editor...
Friday, 19 January 2018

How to use "Toad for Oracle" Help?

›
e.g. Toad for Oracle -> Help -> Contents -> Search "Debugging a Procedure or Function Tutorial"
Tuesday, 13 December 2016

How to compare schemas in Toad?

›
Open two connections like " HR" and "HRNEW" -> Database -> Compare -> Schemas -> Define Source and Target ...
Tuesday, 29 November 2016

How to enable debug mode?

›
SQL> GRANT DEBUG CONNECT SESSION TO hr; SQL> GRANT DEBUG ANY PROCEDURE TO hr; Lastly, reconnect to the session and try again :)
Monday, 7 November 2016

How to import old Toad profile for new one?

›
Export old  User Files from  %USERPROFILE%\AppData\Roaming\Quest Software Import them to %USERPROFILE%\AppData\Roaming\Quest Software u...
Thursday, 27 October 2016

How to configure instant client for Toad?

›
-> unrar .zip file  e.g. C:\oracle_client\12.1.0\client_1 -> add this to "Environment Variables-> Path " That'...
Monday, 3 October 2016

How to define "Auto Replace" in Toad?

›
e.g. View -> Toad Options -> Editor -> Behavior -> Auto replace -> Add -> enter " *s* " as value and " ...

Useful tool shortcuts

›
TOAD Shift + Ctrl + f -> Format code Shift + b -> Comment out code Ctrl + Shift + b  -> Uncomment code Ctrl + z -> Undo Ct...