White Papers

Building Queries Visually

Overview 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.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
Oracle
File Format
HTML
Date Published
Mar 29, 2008
Format
White Papers
Topics
Application Development, Programming Languages, Database Management

Similiar White Papers

MSDN Webcast: Offline Data Synchronization With the Microsoft Sync Framework (Level 100)

MSDN Webcast: Offline Data Synchronization With the Microsoft Sync Framework (Level 100)

The Microsoft Sync Framework is a comprehensive synchronization platform, enabling collaboration and offline scenarios f

Publisher: Microsoft Tips  |  Tags: applications, data, network

Exploring Secrets of BindingSource Filters

Exploring Secrets of BindingSource Filters

Visual Studio gives developers the extraordinary capability to build a database application with a working graphical use

Publisher: Jupitermedia  |  Tags: database, developers, network

MSDN geekSpeak: Advanced T-SQL Techniques With Tobias Thernstrom

MSDN geekSpeak: Advanced T-SQL Techniques With Tobias Thernstrom

The presenter of this webcast shares his knowledge and experience around a particular developer technology. The attendee

Publisher: Microsoft

Cool Features for SQL Server 2008

Cool Features for SQL Server 2008

Are you ready to change the way you administer and develop SQL Server? Scheduled for release this year, SQL Server's fi

Publisher: Quest Software  |  Tags: management

Car Dealer Triples Development Speed With Agile Methods and Visual Studio Team System

Car Dealer Triples Development Speed With Agile Methods and Visual Studio Team System

DriveTime, a used-car and finance company for people with less-than-perfect credit, has more than 100 dealerships in the

Publisher: Microsoft  |  Tags: data, software

Oracle White Papers

A Taxonomy of the Linux Network Stack

A Taxonomy of the Linux Network Stack

This paper tries to give readers not familiar with the Linux network stack a gentle introduction to the fundamental conc

Publisher: Oracle  |  Tags: data, ip, kernel, linux, network

GUIDEBOOK: ORACLE'S SIEBEL CRM ON DEMAND

GUIDEBOOK: ORACLE'S SIEBEL CRM ON DEMAND

Oracle's Siebel CRM On Demand has leveraged its history and experience in CRM to provide customers with deeper functiona

Publisher: Oracle  |  Tags: crm

Oracle Forms 10g - Forms Look and Feel

Oracle Forms 10g - Forms Look and Feel

Oracle Forms application have traditionally behaved as, and looked like, desktop applications. Even when Oracle Forms ap

Publisher: Oracle  |  Tags: applications, css

Oracle Blends Managed Services With OnDemand Pricing

Oracle Blends Managed Services With OnDemand Pricing

Growing businesses are increasingly realising that Managed Services offer a scalable, flexible route forward. This white

Publisher: Oracle

Ten Things to Know About Grid Computing on Windows

Ten Things to Know About Grid Computing on Windows

This Oracle whitepaper offers insights into Oracle Grid.A grid allows a business to add capacity, cheaply, whenever it i

Publisher: Oracle  |  Tags: application server, computing, database, server