#pl sql

Include additional attachments in IFS e-mail report

One of our customers came up with a bit of a challenging requirement. Upon emailing a report to their clients, they need to attach documents connected to that record instance along with the mail. To attach a file in the event mail, you need to either have it as a binary object or the file must exist in the application server.

Requirement in detail:

Customer wants to attach documents…

eGlobalSystems Offering  pl /sql Real-time Online Training Classes For Weekend And Regular Batches For Individuals And Professionals. eGlobalSystems   Offering Free DEMO/ Seminar On  pl /sql Access Control By Real Time Expert. Once Experience Our Free Sessions And Decide Further.

Locations: Hyderabad, India, USA, UK, Australia, New Zealand, UAE, Saudi Arabia,Pakistan, Singapore, Kuwait Etc…

For more details plzz go through the link:

http://eglobalsystems.com/online-core-java-course-training-contents/

contact us:

[email protected]

+91-9948557100

Oracle SQL Developer : Tips and Tricks ☞ http://on.codek.tv/EkoejXjhl

Lesson learned today:

First:

You can’t do a contains without creating an creating an index of type: CTXSYS.CONTEXT

Like so:

create index <whatever_you_want_to_name_the_index> on <table_name>(<column_name>) INDEXTYPE IS CTXSYS.CONTEXT;

I wanted to to look at the records in which a column has a particular substring values. I figured there would be a contains function that I could use.  #NOPE 

select * from <table_name> where contains (<column_name>, '<sub_string_value>', 1) > 0; - doesn’t work.

select * from <table_name> where contains (<column_name>, '<full_string_value_in_record>', 1) > 0; - does work

(via https://www.youtube.com/watch?v=2MNmodawvnE)

Useful sql Query package procedure function. #tip #howto #convert #encrypt #decrypt.