Code to search Customer name from Customer ID

I have one textbox like ID (Cust_ID), Search Button and a Label , When I click on the Button, then search ID in the Database (oracle) then Name(Cust_Name) will be displayed in the label, For this what will I do..?

Plz.. give the Oracle code and help me...

[B]Question asked by visitor Purna[/b]

Hi Purna,

Use this query,
SELECT cust_name FROM CUSTOMER
WHERE cust_id = ID;

ID is the passed textbox value.