How to edit Oracle data using #dbForge Studio for Oracle

How to edit Oracle data using #dbForge Studio for Oracle


Learn how to edit #OracleData using Devart's development tool - dbForge Studio for Oracle.
More: https://www.devart.com/dbforge/oracle/studio/oracle-sql-editor.html

#Oracle
#OracleDevelopment
#OracleTools
Closed Caption:

Welcome to Data Editor Tutorial. It helps you:
- search and filter data in the grid,
- export data to a spreadsheet application,
- view related tables data by one click,
- create a query and a chart in no time.
Select the Employees table in the Database
Explorer window.
Click Retrieve Data to open the data editor.
Click Visible Columns from the data editor
context menu.
Uncheck the commision_pct column.
Click Is not null in the Manager ID filter drop-
down list.
Click CTRL+F to find James Landry's record.
Open the department ID drop-down editor.
Change James Landry's department from
Shipping to Sales.
Use the Quick Filter function to select all the
accountants.
Select their IDs, names, and salaries to copy
their personal data to a spreadsheet application.
Click Copy With Header.
Switch to a spreadsheet application
and paste data from the clipboard.
Return to the application and take advantage of
the Data Export wizard.
Select Excel format.
Check Open the result file after export.
Select the columns to export.
Click Export selected rows only.
Click Export.
Here is our result.
Switch to the application.
Click Finish.
Let's create a query for Salary distribution
among the Departments.
Select Send to from the shortcut menu, and
click Query Builder.
Delete the columns you don't need.
Use a drag-drop operation to add the
Departments table to the diagram.
Delete the Department ID join.
Choose Department_Name
and Salary.
Specify Aggregate for the Salary column.
Select a SUM function.
Change an alias.
Click Execute on the Query toolbar.
Here is our result.
Send data to the chart designer to analyze it.
Select the Pie Series chart type.
Click Enabled.
Click Synchronize with point options.
Select Argument and Values in the Point
view combobox.
Specify an argument for a chart.
Select the Salary_Sum column in the Value
combobox.
Set up the legend appearance.
Modify legend alignment
and its direction.
Click Finish.
Preview the chart showing the Departments
Salary destribution in percents.
Enjoy your work with dbForge Studio for Oracle.

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

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
dbForge Studio for Oracle Tutorial
dbForge Studio for Oracle Tutorial

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

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

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.