Why do we need to create database connection?
- Through database connection sql developer talk to Oracle Database
- SQL Developer is just a tool to access databases in a more user-friendly way. You can access database using command prompt as well after downloading Oracle but SQL developer provides better way of accessing and manipulating data.
- SQL Developer connections is used to browse the database, create schema objects, execute and tune ad-hoc SQL statements, run reports against the data dictionary and create, execute and debug PL/SQL.
- SQL Developer is not just for developer using DBA panel, we allows hiding details by applying certain restrictions, in terms of privileges. It is basically in the hand of the Data Base Administrator, to decide what all data is to be shown to which user and what all data is to be hidden from the different users.
To understand what is SQL and why we need database, you can read the below articles:
Article1
Article2
Query: Why do we need to create database connection? Please tell I don't have idea about sql.
Source: ProgramsBuzz Youtube
User: Devendrakumar Suryawanshi
Video Title: Creating a Database Connection using SQL Developer to Oracle Express Database
Video URL: https://youtu.be/U9HGw6m4Uxw