Oracle SQL Developer is an integrated development environment to work with Oracle database. It is available for free. It makes it easy to develop and manage the Oracle database.
Though SQL developer is capable of doing much more, however, we will use it for hands-on and demonstration in this course.
Oracle SQL developer is a SQL client. If you have network connectivity and able to connect to the database, you should be able to connect and execute query in the SQL developer tool.
We can only use the SQL Developer IDE to its full potential if we know some basic stuff about it. Hence, we will go through the different options and how to work with Oracle SQL developer.
Let us go through SQL Developer basics
- Create Connection to a database
- Finding Database Objects
- SQL Developer smart suggestion
- Code outline
- Using SQL Developer Tabs
- Query output section
- SQL Execution Logs
- Query output as grid or script
- Exporting query output
Let us understand these topics so that we can use SQL Developer with ease.