dbForge Studio for Oracle Tutorial

dbForge Studio for Oracle Tutorial


Learn how to create Oracle connection, execute queries, modify schema objects, etc using PL/SQL development tool by Devart
Learn more: http://www.devart.com/dbforge/oracle/studio/
Closed Caption:

Welcome to dbForge Studio for Oracle tutorials.
In this introductory tutorial we'll do the following:
create a database connection, browse some
schema objects and their properties, write a
simple SQL query, execute it and see the data.
Now you can see a product start page.
It contains major features of the product, such as
PL/SQL coding assistant, query profiler, integrated debugger,
import/export data, and database project.
Now let's create the connection.
We pick a server, a username and a password.
You can as well create connection without
oracle client.
Test the connection and let's begin.
Now we see our schema in Database Explorer
window.
Let's take a closer look at the tables and to do
so let's open Object Viewer Window.
It contain three main views: Properties, Text and
Data.
It's useful for examine your schema in details.
Now let's write a query.
For example, let's select all employees from the
marketing department.
As you can see the code completions
suggests columns of the chosen tables.
The JOIN condition is also prompted.
Now let's execute the query.
And here we are... our result.
You have been watching the dbForge Studio
introductory tutorial.
Thank you for your time.

Video Length: 01:17
Uploaded By: Devart
Published: 11/25/2013
View Count: 13,411

Related Software Products
dbForge Studio for Oracle
dbForge Studio for Oracle

Published By:
Devart

Description:
dbForge Studio for Oracle: A PL/SQL IDE With a Debugger, Schema Compare and Reports in One Window dbForge Studio for Oracle is Devart's Windows IDE for Oracle developers and DBAs: a PL/SQL editor with smart completion, a step-by-step debugger, a query profiler, schema and data compare with sync scripts, and data reports. The Professional edition costs $329.95 a year (Standard $169.95, Enterprise $429.95, or perpetual licenses from $339.95), and a...


Related Videos
How to import and export data in Oracle [Without Coding!]
How to import and export data in Oracle [Without Coding!]

Video Length: 07:41
Uploaded By: Devart (1/25/2022)
View Count: 3,435

How to edit Oracle data using #dbForge Studio for Oracle
How to edit Oracle data using #dbForge Studio for Oracle

Video Length: 03:17
Uploaded By: Devart (2/13/2014)
View Count: 1,876

Best Oracle Report Builder Alternative: Create Reports Easily with dbForge Studio
Best Oracle Report Builder Alternative: Create Reports Easily with dbForge Studio

Video Length: 04:10
Uploaded By: Devart (10/7/2021)
View Count: 1,231

How to compare two Oracle schemas using dbForge Studio for Oracle?
How to compare two Oracle schemas using dbForge Studio for Oracle?

Video Length: 02:44
Uploaded By: Devart (2/13/2014)
View Count: 1,220

How to Compare and Synchronize Oracle Database Schemas using dbForge Studio for Oracle
How to Compare and Synchronize Oracle Database Schemas using dbForge Studio for Oracle

Video Length: 03:17
Uploaded By: Devart (6/7/2021)
View Count: 1,075

How to Install dbForge Studio for Oracle on Linux
How to Install dbForge Studio for Oracle on Linux

Video Length: 06:32
Uploaded By: Devart (5/23/2023)
View Count: 459

Copyright © 2026, Ivertech. All rights reserved.