MIS 325 Lecture Notes - Lecture 6: Oracle Sql Developer, Oracle Database, Sql*Plus

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 325
• Professor: Ayvaci

Document Summary

Chapter 2: how to use oracle sql developer and other tools. Starts automatically when you start your computer. Receives sql statements that are passed to it, processes them, and returns the results. Database listener: listens for requests from remote clients and returns the results to them. Database home page: a web-based tool that you can use to work with an oracle. Sql*plus: a command-line tool you can use to work with an oracle database. Connect: connects to the database as a different user. You can create or export/import data connections. Each connection provides access to database objects. Edit table dialog box: use to modify tables. Display the code completion list: ctrl + spacebar. You can drag snippets into your code from the snippets window. Omitting the closing quotation mark of a character string. Sql script: a file that contains one or more sql statements.