![]() ![]() Linux or Mac OS X: ~/.sqldeveloper/systemn.n.n.n.n Windows: C:\Documents and Settings\\Application Data\SQL Developer\systemn.n.n.n.n sqldeveloper.)ĭefault Locations for user-related information resource type system are mentioned as follows (Windows, Linux, or Mac OS X): (Note the period in the name of any directory named. The user-related information is stored in or under the IDE_USER_DIR environment variable location, if defined, otherwise as indicated in the following table, which shows the typical default locations (under a directory or in a file) for specific types of resources on different operating systems. In most cases, your user-related information is stored outside the SQL Developer installation directory hierarchy so that it is preserved if you delete that directory and install a new version. User-related information includes user-defined reports, user-defined snippets, SQL Worksheet history, code templates, and SQL Developer user preferences. ![]() SQL Developer stores user-related information in several places, with the specific location depending on the operating system and certain environment specifications. ![]() Managing the system folder and other files You'll create a few connections, touch on the various areas available (such as the SQL Worksheet and Reports navigator), and learn about the control of the windows and general product layout. Once your environment is set up, you can follow a quick product walk-through to familiarize yourself with the landscape. It focuses on the alternative installations available for SQL Developer, where to find the product, and how to install it. This chapter, and indeed the rest of the book, is written with the assumption that you have a computer with Microsoft Windows, Linux, or Mac OS X installed, and that you have access to an Oracle database. The best way to learn is by practice, and for that you'll need a computer with access to an Oracle database and SQL Developer. SQL Developer 4.1 is easy to set up and use, so there is very little setup required to follow the examples in this book. This initial chapter is all about preparing your environment, installing SQL Developer 4.1, and getting started. The progression through the chapters is from the more frequently-used features to those less-frequently used. This book is divided into chapters that focus on the different areas or functionality in the recently released SQL Developer 4.1. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.Ĭhapter 1. Getting Started with SQL Developer 4.1 This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. ![]() At times, DBAs support 100s of databases at work. ![]()
0 Comments
Leave a Reply. |