EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

What is SQL Developer?

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » SQL Tutorial » What is SQL Developer?

What is SQL Developer

Introduction to SQL Developer

SQL Developer provides a workspace for the development of the databases using the SQL programming, which is known as Integrated Development Environment or IDE. It is an open source tool provided by Oracle that has user-friendly Graphical User Interface (GUI) and supports all the other tools from Oracle. SQL is the widely used application software, as it is facilitates various operations in one place, such as DBA processes, workspace to create and run queries, UI for report generation, etc

Steps to install the SQL Developer

  1. You can install it from Oracle website but you need to have an account on it, to create an account.
  2. Install the required version of the Oracle SQL Developer.
  3. Install Oracle Database 10g and Sample Schema.
  4. Unlock the HR user and log in as the SYS user and type command: alter user hr identified by hr account unlock;
  5. Download and unzip the files.zip that contains all required files to a local folder on your system.

The first task after installation is to create a connection to the Oracle Database using Oracle SQL Developer.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Steps to Create Database Connection

Following are the steps to create database connection.

1. Open Oracle SQL Developer.

Open Oracle SQL Developer

2. Now under Connections, right click on the Connections and the Connection menu appears. Click on New Connection.

SQL Developer on New Connection

3. The New/Select Database Connection Dialog Box will appear.

SQL Developer Dialog Box

4. Enter the following details in the fields of the above-appeared dialog box.

  • Connection Name: Name of Cloud Connection.
  • User Name: Database Username
  • Password: Your choice (then check the checkbox Save Password)
  • Hostname: Your local hostname
  • SID: Your own SID
  • Then click on Test.

For example:

select database

5. You can check the status of testing on the left bottom side. Then click connect and save.

SQl Developer left buttom side

6. The connection would be saved and the new connection would appear under

Popular Course in this category
SQL Training Program (7 Courses, 8+ Projects)7 Online Courses | 8 Hands-on Projects | 73+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (5,619 ratings)
Course Price

View Course

Related Courses
JDBC Training (6 Courses, 7+ Projects)PHP Training (5 Courses, 3 Project)Windows 10 Training (4 Courses, 4+ Projects)PL SQL Training (4 Courses, 2+ Projects)Oracle Training (14 Courses, 8+ Projects)

under Connections

After creating a connection you can use existing objects of Oracle SQL Developer or can create new also. Now let us see how to browse already existing objects.

Browsing Objects in Oracle SQL Developer

1. Expand the newly added connection.

SQL table newly added

You can use any object like tables, views, indexes, packages, triggers, sequences, synonyms, directories, types, materialized views, functions and many more.

But we will see in brief how we can use tables.

2. Expand Tables.

Expand Tables database

3. You can select any table from the list to view the table definition and click the Data tab.

In the figure below we have selected DEPARTMENTS table.

You can then see the data present in the table.

SQL DEPARTMENTS

You can apply various operations on a table like sorting, filtering data, applying various constraints and many more. You can apply to sort by clicking the arrow icon next to the name of the column you want to sort.

filtering data SQL database

Creating Objects in Oracle SQL Developer

You can create dialogs for each supported object type. Oracle SQL Developer also supports Temporary tables, External tables, list, Partitioned tables, Index Organised tables and many more object types.

1. Right-click on

2. Select a New Table.

Select New Table

3. Enter the Table Name and check the Advanced

Table Name

4. Enter information for the first column as mentioned below:

  • Column Name: Performance_id
  • Type: VARCHAR
  • Size: 3
  • Not Null: Select it
  • Primary Key: Select it

5. Enter information for the second column as below:

  • Column Name: Name
  • Type: Varchar
  • Size: 40
  • Not Null: Select it
  • Primary Key: Leave it

6. Similarly, enter information for as many columns you require.

7. Click OK.

8. The new table would be created under TABLES.

9. To see it, you can expand the TABLES and then use it to perform SQL commands.

The Not Null and Primary Key is the integrity constraints which states what type of data can be inserted in each column. There are more integrity constraints that can be applied to restrict the type of data that is valid for a respective column.

Let us briefly see what these integrity constraints do. There are basically five integrity constraints:

  • NOT NULL: This constraint ensures that data must be present in that column. A null value cannot be inserted in that column.
  • Unique: This constraint ensures that each value in the column must be unique i.e. no repetition of values. This constraint can be applied on multiple columns together as a group called as Composite Unique It does not say anything about Null value.
  • Primary Key: This constraint ensures the properties of both NOT NULL and UNIQUE constraint i.e. multiple rows cannot have the same value and also prevents null value at the same time.
  • Foreign Key: This constraint states that for each value in the column on which the constraint is applied, there must be the same or matching values in other specified table and column. It is basically called referencing other tables.
  • Check: This constraint is not used frequently but it ensures that values must satisfy the specified condition. The condition can be the logical expression or comparison expression depending upon the need for the restrictions to be applied.

Recommended Articles

This has been a guide to What is SQL Developer. Here we discussed how to install and to create a new database of SQL Developer. You can also go through our other suggested articles –

  1. A career in SQL Server
  2. Differences of PL SQL vs SQL
  3. Oracle vs MSSQL – Comparison
  4. Career in Oracle

SQL Training Program (7 Courses, 8+ Projects)

7 Online Courses

8 Hands-on Projects

73+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

4 Shares
Share
Tweet
Share
Primary Sidebar
SQL Tutorial
  • Basic
    • What is SQL
    • Careers in SQL
    • Careers in SQL Server
    • IS SQL Microsoft?
    • SQL Management Tools
    • What is SQL Developer
    • Uses of SQL
    • How to Install SQL Server
    • What is SQL Server
    • Database in SQL
    • SQL Data Types
    • SQL Keywords
    • Composite Key in SQL
    • SQL Constraints
    • Transactions in SQL
    • First Normal Form
    • SQL Server Data Types
    • SQL Administration
    • SQL Variables
    • SQL Enum
    • Cheat sheet SQL
  • Operators
    • SQL Operators
    • SQL Arithmetic Operators
    • SQL Logical Operators
    • SQL String Operators
    • Ternary Operator in SQL
  • Commands
    • SQL Commands
    • SQL Alter Command
    • SQL Commands Update
    • SQL DML Commands
    • SQL DDL Commands
    • FETCH in SQL
  • Clause
    • SQL Clauses
    • SQL IN Operator
    • SQL LIKE Clause
    • SQL NOT Operator
    • SQL Minus
    • SQL WHERE Clause
    • SQL with Clause
    • SQL HAVING Clause
    • GROUP BY clause in SQL
    • SQL GROUP BY DAY
    • ORDER BY Clause in SQL
    • SQL ORDER BY CASE
    • SQL ORDER BY DATE
    • SQL ORDER BY Alphabetical
    • SQL ORDER BY Ascending
    • SQL Order by Count
    • SQL GROUP BY Month
    • SQL GROUP BY Multiple Columns
    • SQL GROUPING SETS
  • Queries
    • SQL Insert Query
    • SQL SELECT Query
    • SQL SELECT RANDOM
    • SQL Except Select
    • SQL Subquery
    • SQL SELECT DISTINCT
    • SQL WITH AS Statement
  • Keys
    • SQL Keys
    • Primary Key in SQL
    • Foreign Key in SQL
    • Unique Key in SQL
    • Alternate Key in SQL
    • SQL Super Key
  • Functions
    • SQL Date Function
    • SQL String Functions
    • SQL Compare String
    • SQL Window Functions
    • SQL Timestamp
    • SQL TO_DATE()
    • SQL DATEADD()
    • SQL DATEDIFF()
    • ANY in SQL
    • LIKE Query in SQL
    • BETWEEN in SQL
    • LTRIM() in SQL
    • TOP in SQL
    • SQL Select Top
    • Merge SQL
    • SQL TRUNCATE()
    • SQL UNION
    • SQL ALL
    • SQL INTERSECT
    • SQL Alias
    • SQL Server Substring
    • CUBE in SQL
    • SQL RANK()
    • SQL MOD()
    • SQL CTE
    • SQL LAG()
    • SQL MID
    • SQL avg()
    • SQL WEEK
    • SQL DELETE
    • SQL DATEPART()
    • SQL DECODE()
    • SQL DENSE_RANK()
    • SQL NTILE()
    • SQL NULLIF()
    • SQL Stuff
    • SQL Ceiling
    • SQL EXISTS
    • SQL LEAD()
    • SQL COALESCE
    • SQL BLOB
    • SQL ROW_NUMBER
    • SQL Server Replace
    • SQL Server Permission
    • T-SQL INSERT
    • SQL Ranking Function
  • Joins
    • Join Query in SQL
    • Types of Joins in SQL
    • Types of Joins in SQL Server
    • SQL Inner Join
    • SQL Join Two Tables
    • SQL Delete Join
    • SQL Left Join
    • SQL Right Join
    • SQL Cross Join
    • SQL Outer Join
    • SQL Full Join
    • SQL Self Join
    • Natural Join SQL
    • SQL Multiple Join
  • Advanced
    • SQL Formatter
    • SQL Injection Attack
    • Aggregate Functions in SQL
    • IF ELSE Statement in SQL
    • SQL CASE Statement
    • SQL While Loop
    • SQL INSTR()
    • What is Procedure in SQL
    • Stored Procedure in SQL?
    • SQL Server Constraints
    • SQL DELETE ROW
    • Column in SQL
    • Table in SQL
    • SQL Virtual Table
    • SQL Merge Two Tables
    • SQL Table Partitioning
    • SQL Temporary Table
    • SQL Clone Table
    • SQL Rename Table
    • SQL LOCK TABLE
    • SQL Clear Table
    • SQL DESCRIBE TABLE
    • SQL Mapping
    • Cursors in SQL
    • AND in SQL
    • Wildcard in SQL
    • SQL FETCH NEXT
    • SQL Views
    • SQL Delete View
    • Triggers in SQL
    • SQL UPDATE Trigger
    • SQL AFTER UPDATE Trigger
    • SQL Update Statement
    • SQL DROP TRIGGER
    • Types of SQL Views
    • SQL Port
    • SQL Clustered Index
    • SQL COMMIT
    • Distinct Keyword in SQL
    • PARTITION BY in SQL
    • SQL Set Operators
    • SQL UNION ALL
    • Metadata in SQL
    • SQL Bulk Insert
    • Array in SQL
    • SQL REGEXP
    • JSON in SQL
    • SQL For loop
    • EXPLAIN in SQL
    • SQL Cluster
    • SQL Backup
    • SQL Pattern Matching
    • SQL Users
    • ISNULL SQL Server
    • SQL pivot
    • SQL Import CSV
  • Interview Questions
    • SQL Interview Questions
    • Advance SQL Interview Questions
    • SQL Joins Interview Questions
    • SQL Server Interview Questions

Related Courses

JDBC Training Course

PHP course

Windows 10 Training

SQL Course Training

PL/SQL Certification Courses

Oracle Certification Courses

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - SQL Training Program (7 Courses, 8+ Projects) Learn More