Auto load SQL on HTML

[848lu]

hi, i was wandering how do i take info from a database and use SQL
to automatically display the info on a HTML, when the file loads up or the webpage


thanks

[debasisdas]

Only HTML can't be used to connect to database.

[848lu]

nah i mean...cant i have some kinda of tigger to activate a stript....


so when the page loads...for example home page...it activates the code...and displayed the data stored in the oracle database...obviously i will use SQL to connect to the database

[amitpatel66]

nah i mean...cant i have some kinda of tigger to activate a stript....


so when the page loads...for example home page...it activates the code...and displayed the data stored in the oracle database...obviously i will use SQL to connect to the database

From SQL PLUS you can display the data in HTML format using the following simple command:

set markup HTML on
spool index.html
select * from tab;
spool off
set markup HTML off
 

You can deploy this file on your web site or edit it in an HTML editor (like FrontPage or Dreamweaver). Another good idea is to develop a CSS to present the data more elegantly. One can also embed HTML tags in the select statement to create hyperlinks and add more HTML features.

I hope this is what you are looking for!!

[848lu]

so does that code into html?


thanks....can you explain how that piece of code works

[debasisdas]

so does that code into html?


thanks....can you explain how that piece of code works

Folllow a good book for the purpose.