sql/plsql code for Document Retrieval system URGENT..

[rajesh_tns]

Hi all,

I need help from you all on something which i never ever worked before..

There is a content management system which stores some contents like documents,images, etc....

I will have to write a code that retrieves the content based on content name as input...

It includes following steps..

1) Extract content code based on content name
2) Using content code -->i have to retrieve something called constraints from another table
3) Using constraints i will get the values from the table
4) using values i will have to retrieve something called RULES from another table.
5) Using rules i will get the content.

I do not understand what are constraints/rules ..

any one earlier worked on such type of procedures/queries for content retrieval..

JAVA code calls this procedure using tag libraries...

This is all I know about the procedure... Need help on this .. from all of you .Feel free to ask me any questions . I need to write a procedure in the next 3 days ..

thanks and regards
raj

[alf-admin]

raj,

I cannot code this for you.

http://www.databasedesign-resource.com/business-rules.html
http://www.databasedesign-resource.com/referential-integrity.html
http://www.databasedesign-resource.com/oracle-database-constraints.html

If you need coding help, see:

www.rentacoder.com
_________________
All the best,
Alf
Forum Admin
Light travels faster than sound: That's why so many people appear bright until you hear them speak...
www.databasedesign-resource.com
The Database Normalization eBook

[rajesh_tns]

thank u so much...alf i would go through them