How i can connect my website to sql & oracal databsase

Posted on 2005-04-12
Last Modified: 2013-12-01
hi expert, i am new in web programming and design ..
i want to lean how to do only one webpage and retreive records from my sql database or oracal any one which will be faster.
but i don't know what setup/software do i need to connect my webpage with the data base in another pc which has a static ip address.

what i think i need interface to recive the client request execute the command by fetching the data from the database and send it back to the client..
is there any direct why.
where i can read the records from my database directly, when the client click on a command botton.. so i just open a connection to databse and select what ever data i want and display the data on new page. or what ever.
Question by:volanto
    1 Comment
    LVL 13

    Accepted Solution

    You'll need to create a DAD to your database (the connection from mod_plsql to the database) within which your storing your PLSQL, if you've got an Application Server (9IAS or AS10g) then:

    Login to Enterprise Manager ( as ias_admin. Navigate to your HTTP Service (Farm > App Server > HTTP Server > PL/SQL Properties (at the bottom of the screen)) -- scroll down to DAD Status and click Create -- select general as connection type, enter connection string as usual and give your DAD a name (you'll need this as DADname in the URL below).

    If your just using the database the you'll need to have Apache running on it, then goto http://hostname:80 & click mod_plsql. This reference will guide you through creation of a DAD:

    Once you have a DAD, then create a procedure on that database, example:

         There are currently

    for counter in (SELECT COUNT(*) rowsintable FROM DUAL) loop
         htp.prn(' ');
         htp.prn( counter.rowsintable );
         htp.prn(' ');
    end loop;

    htp.prn(' rows in TABLE1

    Once this has been created you can access it using the following URL syntax:

    This demonstrates several things:

    Use of a DAD to join browser to database
    htp.prn to generate HTML to your browser
    Outputing database information to the browser via a DAD (obviously I'm SELECTing from DUAL you can use any table)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
    This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now