How To Run SQL Statements through the Web Interface

Q

How To Run SQL Statements through the Web Interface? - Oracle DBA FAQ - Managing Oracle Table Indexes

✍: FYIcenter.com

A

If you don't like the command line interface offered by SQL*Plus, you can use the Web interface to run SQL statements. Here is how:

Open your Web browser to http://localhost:8080/apex/
Log in to the server with the predefined sample user account: HR/fyicenter
Click the SQL icon
Click the SQL Commands icon
Enter any SQL statement like: "SELECT COUNT(*) FROM USER_TABLES;", in the text area and click Run button
Your Oracle will execute the statement, and display the result in the result area.

2007-05-02, 5153👍, 0💬

How To Import One Table Back from a Dump File
How To Import One Table Back from a Dump File? - Oracle DBA FAQ - Loading and Exporting Data If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import th... 2007-05-02, 5661👍, 0💬

How To List All Indexes in Your Schema
How To List All Indexes in Your Schema? - Oracle DBA FAQ - Managing Oracle Table Indexes If you log in with your Oracle account, and you want to get a list of all indexes in your schema, you can get it through the USER_INDEXES view with a SELECT statement, as shown in the following SQL script: SELEC... 2007-05-02, 5398👍, 0💬

What Is an Index Associated with a Constraint
What Is an Index Associated with a Constraint? - Oracle DBA FAQ - Managing Oracle Table Indexes An index associated with a constraint because this constraint is required to have an index. There are two types of constraints are required to have indexes: UNIQUE and PRIMARY KEY. When you defines a UNIQ... 2007-05-02, 5298👍, 0💬

How To Rename an Index
How To Rename an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes Let's say you have an existing index, and you don't like its name anymore for some reason, you can rename it with the ALTER INDEX ... RENAME TO statement. Here is an example script on how to rename an index: CREATE TABLE studen... 2007-05-02, 5292👍, 0💬

How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you ho... 2007-05-02, 5256👍, 0💬

How To Create a Table Index
How To Create a Table Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use th... 2007-05-02, 5156👍, 0💬

How To Run SQL Statements through the Web Interface
How To Run SQL Statements through the Web Interface? - Oracle DBA FAQ - Managing Oracle Table Indexes If you don't like the command line interface offered by SQL*Plus, you can use the Web interface to run SQL statements. Here is how: Open your Web browser to http://localhost:8080/apex/ Log in to the... 2007-05-02, 5154👍, 0💬

What Happens If the Imported Table Already Exists
What Happens If the Imported Table Already Exists? - Oracle DBA FAQ - Loading and Exporting Data If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: >cd \oraclexe\ap... 2007-05-02, 5145👍, 0💬

How To Drop an Index
How To Drop an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(8... 2007-05-02, 5101👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.