Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


urgent help plsssss....

bye1998bye1998 Member Posts: 3
Any one pls help me....

Using the table

create table person(
person_id number primary key,
name varchar2(100),
address varchar2(200));

Is accessible through the DSN string "DSN=ThisDatabase", write the ADO code in VB, ASP, or other valid language that uses ADO to query the database and place all records of the name field in the array names() with the name 'Doe' anywhere in the name. At the end of the procedure you should have an array of strings that should look something like;

names(1) = "John Doe"

names(2) = "Fred Doe"


Equation Create new equation


Write a PL/SQL procedure that will look at each table in your schema that will give the following information;

You may do this with a single procedures, multiple procedures, or a package - be sure to put all code in this WIndow

Equation Create new equation

Sign In or Register to comment.