Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Hostname |
Required |
Only environment variables are available. |
Enter the host name of database. |
- Disabled if [Enter the URL directly] is checked.
|
Port number |
Optional |
Only environment variables are available. |
Enter the port number of database.
The default number is "1521". |
- Disabled if [Enter the URL directly] is checked.
|
SID |
Required |
Only environment variables are available. |
Enter the database SID. |
- Disabled if [Enter the URL directly] is checked.
|
URL |
Required |
Only environment variables are available. |
Enter the URL.
The URL format of Oracle is "jdbc:oracle:thin:@<hostname>:<port number>:<SID>". |
- Enabled if [Enter the URL directly] is checked.
|
Enter the URL directly |
Required |
|
Select whether to directly enter the URL of the Oracle database to connect.
- [Checked]:
Enter the URL directly.
- [Not Checked]: (default)
The URL is generated based on the settings of [Hostname], [Port number], and [SID].
|
|
User name |
Required |
Only environment variables are available. |
Enter the user name. |
|
Password |
Optional |
Only environment variables are available. |
Enter the password. |
|
Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Specify the number of tables in the list |
Optional |
Not available |
Select whether to limit the number of tables listed or not.
- [Checked]:(default)
limit the number of tables names listed.
- [Not Checked]:
Table names listed are not limited. Fetches all of the table names available.
|
|
Number of tables |
Optional |
Available |
Enter a number of tables listed.
|
-
Enabled when [Specify the number of tables in the list] is checked.
-
Defaults to 500 if omitted.Defaults to 500 if omitted, or if the value specified is invalid.
|
Specify the number of procedures in the list |
Optional |
Not available |
available Select whether to limit the number of procedures or not.
- [Checked]:(default)
limit the number of procedures listed.
- [Not Checked]:
Procedure names listed are not limited. Fetches all of the procedure names.
|
|
Number of procedures |
Optional |
Available |
limit the number of the procedures listed.
|
-
Enabled when [Specify the number of procedures in the list] is checked.
-
Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.
|