User Manual
This is a Tool, which will work only with Oracle as Backend. The Main Functionality of this is as follows.
- We can apply all the Sql commands. Like
Select
Delete
Create Table /Index/Sequence
Alter Table
- We can able to See all the Table Name/Indexes & View Name
- We Can Get the Explain Plan for any Sqls
The Main Screen Look Like as follows
Details
The First Step what we have to do is, we have to connect to Oracle. For that in this Tool, I have given Icon as follows.
This is an Icon, which will let you connect to an Oracle DB. If you click on this Icon, a separate window will come, it will ask you for some parameter, after filling these parameters, it will connect to the oracle db.
This is a screen shot of the Connection Option.
After Filling the UserId ,Password & Server, if the Parameters are correct, it will connect to the oracle.
After that we can apply all the commands. We have to apply the command in the Main Window, which is in white color, that is the Command Window. Assume that we are applying the following command in the command window.
SELECT DEPTCODE,DEPTNAME FROM FOMDEPT WHERE DEPTCODE = �PHA�
After you have typed this command we have to select the entire command and then we have to execute. To execute the selected command in this tool there is an icon like this
If you press this icon the result will display in the bottom window, in the Bottom window there are 2 tabs there. One �Query� Tab is to view the output and �Output� tab will returns, how much rows affected like.
For any kind of commands if you type in the command window when you want to execute. The user has to block the command what they want to execute and then they have to press the execute button.
This is one icon in that tool, which will used to find the Table Structure and the Indexes if any.
How to use that option, type any table name in the command window and block the table name, after that press this button. Then the output looks like this
I have typed �ADMUSERS� in the command window, I blocked the text, and pressed the �Find Object� option. Then the result looks like the above. It is telling the Field Name in the table �AdmUsers� and the Indexes and its column.
This is one icon in that tool, this will tell us the explain plan of the selected sql command.
For an Example I have typed the following command in the command window and press the explain plan button. The result looks like this.
SELECT DEPTCODE,DEPTNAME FROM FOMDEPT WHERE DEPTCODE = �PHA�
This is one option this will tell all the Table Details, Index & View Details. The Output looks like below.
The above output contains 3 tabs, The First tab tells you about the table details, the second one is for the indexes and the third one is for the views.
This button is for commit if any delete/update statement.
This is to Rollback.
This is to disconnect the connection.
Technical Stuff in this Project
To List the output of any sql query command, I have used List View, this list view having a facility to sort by any column.
For the Explain Plan we should need the �plan_table� this is the inbuilt table of oracle suppose if u r not having, please create the table, the structure of the table is as follows.
SQL> DESC plan_table
Name Null? Type
STATEMENT_ID VARCHAR2(30)
TIMESTAMP DATE
REMARKS VARCHAR2(80)
OPERATION VARCHAR2(30)
OPTIONS VARCHAR2(255)
OBJECT_NODE VARCHAR2(128)
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
OBJECT_INSTANCE NUMBER(38)
OBJECT_TYPE VARCHAR2(30)
OPTIMIZER VARCHAR2(255)
SEARCH_COLUMNS NUMBER(38)
ID NUMBER(38)
PARENT_ID NUMBER(38)
POSITION NUMBER(38)
COST NUMBER(38)
CARDINALITY NUMBER(38)
BYTES NUMBER(38)
OTHER_TAG VARCHAR2(255)
PARTITION_START VARCHAR2(255)
PARTITION_STOP VARCHAR2(255)
PARTITION_ID NUMBER(38)
OTHER LONG
DISTRIBUTION VARCHAR2(30)
CPU_COST NUMBER(38)
IO_COST NUMBER(38)
TEMP_SPACE NUMBER(38)
ACCESS_PREDICATES VARCHAR2(4000)
FILTER_PREDICATES VARCHAR2(4000)
