Later in this book, you'll learn more about views, indexes, and other database objects. For this chapter, however, you can focus on the tables. These database objects include tables, views, indexes, and so on. How to navigate through the database objectsįigure 2-5 shows how to navigate through the database objects that are available to the user that corresponds with the current database connection. To import connections, right-click the Connections node, select the Import Connections command, and use the resulting dialog box to navigate to the XML file for the connections.To export database connections, right-click the Connections node, select the Export Connections command, and use the resulting dialog box to select the connections that you want to export and to specify the path and filename for the XML file for the connections.When you do, the connection will be added to the dialog box and to the Connections window. Click the Save button to save the connection. If the connection works, a success message is displayed above the Help button.Ĥ. Click the Test button to test the connection. Enter a connection name, username, and password for the connection.ģ. Right-click on the Connections node in the Connections window and select the New Connection command to display the dialog box for creating database connections.Ģ. The dialog box for creating database connectionsįigure 2-4 How to create, export, or import a database connectionġ. For example, I exported the database connections for the AP, OM, and EX users to this file:Ĭ:murachoracle_sqldb_setupconnections.xmlĪs a result, if you want, you can use the technique shown in this figure to import the connections that are stored in this file. Then, you can use this XML file to import those database connections on another computer. If you want to copy several database connections from one computer to another, you can export the database connections to an XML file as described in this figure. How to export or import database connections In this figure, for example, I entered the usernames and passwords in lowercase because it's easier to type in lowercase. As a result, it doesn't matter if you enter the usernames and passwords in uppercase or lowercase. When you create a database connection, you should note that the usernames and passwords are not case-sensitive. Specifically, we suggest that you use the AP user to work with the tables in the AP schema, the OM user to work with the tables in the OM schema, and the EX user to work with the tables in the EX schema. As a result, you will be able to create connections for these three users. If you have installed the software for this book as described in figure A-5 of appendix A, the AP, OM, and EX users with passwords of AP, OM, and EX will be available on your system. To create a new connection, you can use the procedure described in figure 2-4. When you start SQL Developer, the Connections window displays all available database connections. To connect to earlier versions, you need to use another tool such as the SQL*Plus tool described in the previous figure.īefore you can work with a database, you need to create a connection to the database. When you use SQL Developer, you can connect to any Oracle Database version 9.2.0.1 or later. This chapter is excerpted from the book, Murach's Oracle SQL and PL/SQL, authored by Joel Murach, published by Mike Murach & Associates, Inc., August, 2008. However, with some minor variations, the skills presented in this chapter should work for later versions as well. As you will see, this tool makes it easy for you to review or modify the design of a database.Īs of press time for this book, the current version of SQL Developer is version 1.5, so that's the version presented in this chapter. Oracle SQL Developer is a free graphical tool that makes it easy to work with Oracle databases, and it's the tool that we recommend for working with an Oracle database. How to use the Oracle Database SQL Reference manual How to use SQL Developer to run SQL statements How to view and edit table column definitions How to use SQL Developer to work with an Oracle database How to work with the Oracle database home page
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |