SQL Tool designed using VB.NET

• Download source - 90.5 Kb

User Manual

This is a Tool, which will work only with Oracle as Backend. The Main Functionality of this is as follows.

1. We can apply all the Sql commands. Like
   1. Select
   2. Delete
   3. Create Table /Index/Sequence
   4. Alter Table
2. We can able to See all the Table Name/Indexes & View Name
3. 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)