Oracle SQL Developer provides the SQL worksheet, a code-editor window where one can enter and run statements that include SQL*Plus commands, SQL, and PL/SQL code - either single statements or multiple-statement scripts. Oracle SQL Developer also facilitates common query tasks with GUI tools. Using point-and-click actions in the Connections Navigator display, one can quickly view the same data that certain manually entered queries retrieve. Drag-and-drop capabilities and the query builder both help one build complex queries more quickly than one can with manual coding. This column takes the user through examples of the point-and-click, drag-and-drop, and query builder approaches, to illustrate their advantages over manual query construction.
Did you find this white paper useful?
2 out of 7 users found this white paper useful
Related white papers
A Novel Coding Technique to Minimise the Transmission Bandwidth and Bit Error Rate in DPSK
This paper proposes a novel coding technique that aims to reduce the Transmission Bandwidth (BT) and Bit Error Rate (BER) vis-a-vis Conventional Differential Phase Shift Keying (CDPSK) in digital band...
Increase Bandwidth in Medical & Industrial Applications With FPGA Co-Processors
Programmable Logic Devices (PLDs) have long been used as primary and co-processors in telecommunications. Digital Signal Processing (DSP) in medical and industrial applications often has fundamental differences from the typical...
MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)
This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, including the hierarchy ID data type, the FileStream object, table-valued parameters, and...
MSDN Webcast: ADO.NET Data Services Overview (Part 1 of 2) (Level 100)
This webcast illustrates how to take advantage of ADO.NET Data Services (formerly code-named Astoria) to easily and securely expose data as services over HTTP. It gives an overview of REST,...
MSDN Webcast: Programming a Full-Blown AJAX Enterprise Application in 20 Minutes (Level 100)
It is all about simplicity when programming next-generation, complex Asynchronous JavaScript And XML (AJAX) applications. This webcast develops a fully blown AJAX enterprise application by dragging and dropping controls using...
Portal Enhances Manageability, Performance, and Security With New Server Solution
CentrumXP.pl, a leading IT-focused Web portal in Poland, showcases the latest Microsoft products and technologies. To demonstrate the advantages of the latest software to users and to improve the site...
MSDN Webcast: Look What You Can Do With Silverlight 2 (Part 3 of 6): Introducing Deep Zoom (Level 200)
The Deep Zoom feature in Microsoft Silverlight 2, which is based on SeaDragon technology from Microsoft Research, allows users to easily and cleanly navigate through very large images and only...
