This is an ASP tutorial. It serves the following purposes:
Suppose, your database contains 200 tables. How you will know what are the names of tables?
You have to open sqlplus and type the statement like this:
Select * from tab.
But If you dont have facility to access sqlplus, then you can write an asp program like this and simply enter the above statement in the form and you will get the output.
To view the list of field names, you can give the statement like:
Select * from emp where rownum=1.
This program have two security concepts. 1. The user can type only the statements, which starts with "select...". He cannot type the statement such as "delete...,update....,insert....".
2. The user has to type a password to get the output.This password value is written in the asp code itself.
|Once you have typed the url: abcinfo.com/select_stt.asp, the following form is displayed. You have to enter the select statement as shown here.and press submit button|
|The output of the above form input:|
Asp file: select_stt.asp
<% If sql <> ""
and permit="yes" then%>