Howdy, Stranger!

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

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

urgent help

bye1998bye1998 Posts: 3Member
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"

etc...

Equation Create new equation




--------------------------------------------------------------------------------


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



TABLE COLUMN CONSTRAINT CONSTRAINT TYPE
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.