Hi,
I was facing couple of issues while deleting the Discoverere 10g workbook from front end.
I successfully deleted the same from backend.
Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.
eg:-
1)select * from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
2)select .DOC_NAME,d.DOC_DEVELOPER_KEY,p.notm,d.notm,d.DOC_DESCRIPTION,p.AP_ID,p.AP_TYPE,p.AP_EU_ID, p.GD_DOC_ID,d.doc_id from eul5_access_privs p, eul5_documents d where p.gd_doc_id=d.doc_id and d.doc_id=121412;
3)select * from eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
4)DELETE FROM eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
5)delete from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
6)commit;
Hope this helps.
Don't forget to give your feedback. :-)
Regards
Guru
9 comments:
Thanks. Great write-up. Was trying to find a while. Longing for many more personal blogs of your stuff in the foreseeable future.
That is certainly wonderful content material. I am going to certainly be running a blog and speaking about the idea. Exactly what I believed i was looking for.
This is exactly what I was looking for! Thanks to you!
Among the best content articles We've ever before studied on this subject matter. Thanks a lot!
The author is really cool. But some of the commentators are just posting stupid words.
hi, new to the site, thanks.
that is definitely what I was searching for, You have saved me alot of time
I am glad to be one of the visitors on this great internet site (:, thankyou for posting .
I've been looking for this info for a long time, thanks for your work.
Post a Comment