{"id":91057,"date":"2025-01-10T17:40:10","date_gmt":"2025-01-10T12:10:10","guid":{"rendered":"https:\/\/cloudfoundation.com\/blog\/?p=91057"},"modified":"2025-01-10T18:03:52","modified_gmt":"2025-01-10T12:33:52","slug":"what-is-toad","status":"publish","type":"post","link":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/","title":{"rendered":"What is Toad for Oracle? A Detailed Toad Tutorial"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#What_is_Toad\" >What is Toad?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#What_are_Toad_Editions\" >What are Toad Editions?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#How_to_access_the_Toad_oracle_interface\" >How to access the Toad oracle interface?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Edge_tool_in_Toad\" >Edge tool in Toad<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#What_is_Syntax_highlighting_in_Toad\" >What is Syntax highlighting in Toad?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#What_is_Toad_Advisor\" >What is Toad Advisor?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Sequel_Tuning_Tool\" >Sequel Tuning Tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Object_Palette_in_Toad\" >Object Palette in Toad<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Code_Roadmaps_in_Toad\" >Code Roadmaps in Toad<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Functional_Testing_Tool_in_Toad\" >Functional Testing Tool in Toad<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Code_Snippet\" >Code Snippet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#What_is_use_of_Code_Analysis_in_Toad\" >What is use of Code Analysis in Toad?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Sequel_Optimizer\" >Sequel Optimizer<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#Auto_Optimizer_in_Toad\" >Auto Optimizer in Toad<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Did You Know, what is Toad and how developing teams often solve problems in understanding schema objects, maintaining code, testing code, finding performance bottlenecks, optimizing SQL statements, and performance testing for production?<\/p>\n<p>Toad offers features to alleviate these issues, such as the schema browser window and the ER diagram.<\/p>\n<p>In this Blog we will going explain how this tool help developers understand the environment they&#8217;re working in and make changes to objects or code without considering the potential impact on other objects in the schema.<\/p>\n<p><img decoding=\"async\" class=\"size-medium aligncenter\" src=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/What-is-Toad.jpg\" alt=\"\" width=\"800\" height=\"600\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_Toad\"><\/span><strong>What is Toad?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Toad Tool is for Oracle Application Developers, a populardevelopment tool and Database Management System. It is mainly used for database administration, development and querying mainly for Oracle databases.<\/p>\n<p>Its not only for oracle databases but also helps other Databases such as PostgreSQL, My SQL and SQL.It Focuses on understanding customers how to interact with databases efficiently, design and execute SQL Queries, toad tools help in optimize administration tasks and manage database.<\/p>\n<p>Toad offers various templates depending on the type of object being created. Users can open existing lists and select from the file system or database to start editing and compiling PL SQL code.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_are_Toad_Editions\"><\/span><strong>What are Toad Editions?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Given below are toad editions:<\/p>\n<p>Base Edition<\/p>\n<p>Professional Edition<\/p>\n<p>Expert Edition<\/p>\n<p>Development Suite.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#0095f2&#8243; background_color_gradient_end=&#8221;#7dbed8&#8243; background_color_gradient_direction=&#8221;92deg&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;73%|62%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/SS_436-_Converted_-1.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;114%|112%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;25px|-4px&#8221; transform_translate_linked=&#8221;off&#8221; width=&#8221;98.1%&#8221; custom_margin=&#8221;|7px|||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;21px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Toad<\/strong> <\/span><span style=\"color: #ffffff;\">Training<\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Explore Course Content&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_access_the_Toad_oracle_interface\"><\/span><strong>How to access the Toad oracle interface?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To access the Toad Oracle interface, first log in to the server and click the Connection button. Choose a direct connection, TNS, file, or LDAP interface. Set a hostname, port number, and service name for the connection.<\/p>\n<p>Set a colour to differentiate between different windows in Toad, especially for production databases.Open the schema browser, which presents object information in various ways.<\/p>\n<p>Choose a multi-tabbed arrangement, which can be changed to a drop-down list, tab single row, or tree view. Expand each node to view objects from different schemas. If you want to change the schema, use the drop-down menu to select a different schema.<\/p>\n<p>The primary tabs display object types, while secondary tabs provide attributes for each object type. For example, if you click on an employee table, you can see columns, indexes, constraints, data, partitions, referential integrity, policies, auditing, and more.<\/p>\n<p><img decoding=\"async\" class=\"size-medium aligncenter\" src=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Toad-oracle-interface.jpg\" alt=\"\" width=\"800\" height=\"600\" \/><\/p>\n<p>Data is a popular option as it was created using a DDL script.To access the data grid in Toad, select the department table and click the Data tab. Turn off any columns you don&#8217;t want to see by selecting the box in the top left column or pulling the column header.<\/p>\n<p>Calculate average values and totals by selecting a range of salaries and using the sum button. Move columns around locally without affecting the database. Save the data into an Excel file by selecting Export dataset, right-clicking, and selecting Excel file.<\/p>\n<p>Change the file name to &#8220;dept&#8221; and launch it after creation. For routine operations, persist the window state by clicking the &#8220;Save load window snapshot&#8221; icon. Save the file as an app and retrieve it using the rerun menu. The editor is a popular window in Toad for working with PL SQL code, scripts, and various types of SQL.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Edge_tool_in_Toad\"><\/span><strong>Edge tool in Toad<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The Edge tool is designed to work with various types of SQL, hexadecimal scripts, and other types of data. It provides a list of previously executed SQL statements, allowing users to select and run them.<\/p>\n<p>The Object Palette and code snippets allow users to access objects from the default schema or different schemas, and display column names for objects.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_Syntax_highlighting_in_Toad\"><\/span><strong>What is Syntax highlighting in Toad?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Syntax highlighting is used to validate object names and key words. The editor can also be integrated with version control.<\/p>\n<p>Version control systems like TFS or subversion can be integrated with the editor through utility cord encoding, which allows code checking in and out.<\/p>\n<p>By double-clicking a store, a PL SQL program in the schema browser is automatically checked out, allowing users to view the code&#8217;s status in the 10 coding Utility window.<\/p>\n<p>This encoding also allows users to search for unfamiliar terms using Jump search, which presents information grouped by Toad and outside of it.<\/p>\n<p>Windows, menus, toolbars, and Toad option settings are all related to PL SQL. Code Analysis rules, code snippets, help, and Toad World are also related to PL SQL.<\/p>\n<p>Users can access information about using PL SQL in Toad by double-clicking Help, which opens a help file.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_Toad_Advisor\"><\/span><strong>What is Toad Advisor?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Toad advisor is a tool that helps improve performance by analysing the operating environment and making recommendations for connection issues. It also helps in adjusting settings for Unicode databases.<\/p>\n<p>The base edition offers core features like debugging and data modelling, while professional editions focus on code quality and data generation.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sequel_Tuning_Tool\"><\/span><strong>Sequel Tuning Tool<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The sequel tuning tool helps identify performance issues and SQL tuning. The development suite covers the entire development lifecycle, including code testing, unit testing, and scalability testing.<\/p>\n<p>For DBAs, the database admin module can be added to Toad, providing additional features not available in the standard version of Toad Oracle.<\/p>\n<p>Toad offers two suites with spotlights, benchmark factory for database workload replay, and backup reporting tool.<\/p>\n<p>The first suite, DBS with Toad, provides real-time diagnostics to diagnose performance problems and resolve them quickly.<\/p>\n<p>The second suite, Recognition, focuses on red cluster environments and the third suite, X-Ray Tradition, examines X data appliances.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Object_Palette_in_Toad\"><\/span><strong>Object Palette in Toad<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The object palette is a slider window that allows users to add tables connected through foreign keys. It allows users to quickly get information about an object by selecting it and pushing the f4 function key.<\/p>\n<p>This allows users to quickly view the table&#8217;s makeup, data, foreign keys, and script. Users can build queries from the table, generate data for tables, and create referential data.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#ff8c7c&#8221; background_color_gradient_end=&#8221;#e5ba4e&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|69%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;||-5px||false|false&#8221; custom_padding=&#8221;|||2px|false|false&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/8423118_3895895.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;85.4%&#8221; custom_margin=&#8221;-31px||-24px||false|false&#8221; custom_padding=&#8221;|22px|0px||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #000000;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <strong>Toad<\/strong> <\/span><span style=\"color: #ffffff;\"><span style=\"color: #000000;\">Online Training<\/span><\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Up Coming Batches&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#E09900&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221; background_layout=&#8221;dark&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Code_Roadmaps_in_Toad\"><\/span><strong>Code Roadmaps in Toad<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The code roadmap is a window for code relationships, looking for CO relationships. It helps developers understand the inner dependency tree and make careful changes to tables.<\/p>\n<p>The toad development suite also allows users to create test cases for all code by selecting a function and launching the code tester.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Functional_Testing_Tool_in_Toad\"><\/span><strong>Functional Testing Tool in Toad<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This functional testing tool allows users to define input values and create test cases for their code.To test a function in Toad, input values and expected outcomes are entered.<\/p>\n<p>Test cases are automatically generated, and if a test case is not built and stored in the code repository, the program can be run to identify failures.<\/p>\n<p>To debug a runtime error, the code must be double-clicked and accessed in the editor. If the code is stored in a version control system, it is automatically checked out and recompiled. The code can then be viewed in the version control system, where the version history is displayed.<\/p>\n<p>The code can be recompiled and checked into the version control system to ensure the functionality is being provided. The code can be accessed in the teen Coding Dashboard to view the version history of the code.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Code_Snippet\"><\/span><strong>Code Snippet<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Code snippet that was checked in today and compared with a prior version using a version control system. The first control system integration through teen coding provides a more seamless way to interact with the birth control system to access code and ensure code integrity.<\/p>\n<p>Code snippets provide access to various code chunks, such as group functions and date functions. Users can also create PL SQL code from scratch using startup templates.<\/p>\n<p><img decoding=\"async\" class=\"size-medium aligncenter\" src=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Code-Snippet.jpg\" alt=\"\" width=\"800\" height=\"600\" \/><\/p>\n<p>The code is then checked out through a debugging session, selecting breakpoints where the code has a runtime error. The code is then debugged using the PL SQL debugger, which compiles with debugging.<\/p>\n<p>The code is then stepped through line by line, evaluating the values that have been resolved. If the code is completed, the profiler is turned off on the main toolbar. The code is then checked for integrity.<\/p>\n<p>The profile tool displays the execution time of each line of code, including the one executed today. It identifies line 17 as the potential bottleneck, which is an embedded SQL statement. To improve the execution time, the user can select the offending SQL statement and launch the sequel optimizer.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_is_use_of_Code_Analysis_in_Toad\"><\/span><strong>What is use of Code Analysis in Toad?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Code analysis is a tool that helps developers identify and correct coding violations in their code. It allows developers to see where violations are, correct them, and demonstrate that they are meeting their standards.<\/p>\n<p>However, for team leads or dev managers with numerous programs, the code analysis dashboard is an efficient way to run a check.<\/p>\n<p>This dashboard allows users to load code from databases or file systems, run a check using desired rules, and see program-by-program coding violations. A preview of the violation is provided for each program, allowing for the generation of a report.<\/p>\n<p>The dashboard can be automated to run the entire process on a weekly cycle. To ensure code scalability in a production environment, benchmark factory is a useful component of the development suite.<\/p>\n<p>This allows users to test a piece of code for performance using standard parameters.To test scalability in production, specify the service level agreement or goal, and set the expected user load. In the benchmark factory, initiate the program and launch it within a second.<\/p>\n<p>The program will run up to 100 virtual users, providing a loading profile and workload assessment. If the program doesn&#8217;t meet production system expectations, consider tuning additional sequels within the application.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sequel_Optimizer\"><\/span><strong>Sequel Optimizer<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The sequel optimizer is a tool that automatically generates rewrites from an original SQL statement, continuously looking for better alternatives with unique execution plans. It can be used to identify issues with a SQL statement and generate an execution plan.<\/p>\n<p>The sequel optimizer comes in two forms:<\/p>\n<p>A full advanced SQL optimization suite.<\/p>\n<p>A tool for developers who are not used to tuning.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Auto_Optimizer_in_Toad\"><\/span><strong>Auto Optimizer in Toad<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The auto optimizer is a great way to find potential rewrites of an SQL statement to fix problems and offer alternatives. The SQL statement has an into line and a locally defined variable, which are not applicable outside the context of the function.<\/p>\n<p>To optimize the SQL, the user must modify the SQL statement, remove the into line, and replace the local variable with a bind variable. The auto optimized SQL window needs information about the application type, such as a general OLTP or data warehouse application.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#494fff&#8221; background_color_gradient_end=&#8221;#9ea6ff&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|71%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/Untitled-11.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;103%|103%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;11px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_padding=&#8221;|88px||||&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #000000;\"><span style=\"color: #ffffff;\"><strong>Toad Course Price<\/strong><\/span><\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/workday-training\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Offer Price&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_team_member name=&#8221;Divya&#8221; position=&#8221;Author&#8221; image_url=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/Divya1.png&#8221; _builder_version=&#8221;4.9.7&#8243; header_level=&#8221;h5&#8243; header_font=&#8221;Titillium Web|700|||||||&#8221; body_font=&#8221;Titillium Web||||||||&#8221; body_font_size=&#8221;16&#8243;]Hello all! I am gonna pop you with the information that will make your life easier.[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] Did You Know, what is Toad [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":91067,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-91057","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-uncategorized"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is Toad for Oracle? A Detailed Toad Tutorial<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Toad for Oracle? A Detailed Toad Tutorial\" \/>\n<meta property=\"og:description\" content=\"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] Did You Know, what is Toad [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudFoundation | Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-10T12:10:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-10T12:33:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Toad.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"447\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"NAGENDRAG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"NAGENDRAG\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Toad for Oracle? A Detailed Toad Tutorial","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/","og_locale":"en_US","og_type":"article","og_title":"What is Toad for Oracle? A Detailed Toad Tutorial","og_description":"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] Did You Know, what is Toad [&hellip;]","og_url":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/","og_site_name":"CloudFoundation | Blog","article_published_time":"2025-01-10T12:10:10+00:00","article_modified_time":"2025-01-10T12:33:52+00:00","og_image":[{"width":500,"height":447,"url":"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Toad.jpg","type":"image\/jpeg"}],"author":"NAGENDRAG","twitter_card":"summary_large_image","twitter_misc":{"Written by":"NAGENDRAG","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/","url":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/","name":"What is Toad for Oracle? A Detailed Toad Tutorial","isPartOf":{"@id":"https:\/\/cloudfoundation.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#primaryimage"},"image":{"@id":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Toad.jpg","datePublished":"2025-01-10T12:10:10+00:00","dateModified":"2025-01-10T12:33:52+00:00","author":{"@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4"},"breadcrumb":{"@id":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudfoundation.com\/blog\/what-is-toad\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#primaryimage","url":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Toad.jpg","contentUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/01\/Toad.jpg","width":500,"height":447},{"@type":"BreadcrumbList","@id":"https:\/\/cloudfoundation.com\/blog\/what-is-toad\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudfoundation.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is Toad for Oracle? A Detailed Toad Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/cloudfoundation.com\/blog\/#website","url":"https:\/\/cloudfoundation.com\/blog\/","name":"CloudFoundation | Blog","description":"A New way of Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudfoundation.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4","name":"NAGENDRAG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","caption":"NAGENDRAG"},"url":"https:\/\/cloudfoundation.com\/blog\/author\/nagendrag\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/91057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/comments?post=91057"}],"version-history":[{"count":6,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/91057\/revisions"}],"predecessor-version":[{"id":91070,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/91057\/revisions\/91070"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media\/91067"}],"wp:attachment":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media?parent=91057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/categories?post=91057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/tags?post=91057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}