Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL package could manipulate Microsoft Word/Excel?

VincelogicFeb 9 2021

Is there any PL/SQL package that in Microsoft Word / Excel, and do operations such as the following tasks:
Parse and go through the whole document
Find a specific string, (ie. A), and replaces it with another string (ie. B)
Add an image
Operate the word table: create a new line, etc.

This post has been answered by GregV on Feb 15 2021
Jump to Answer

Comments

Great article and project! I have a simple question. When you say:

Non-blocking request processing emerges as an effective way to address the problem. Instead of one blocking thread to handle one request, a small number of threads is used to handle a large number of requests asynchronously. This results in more efficient use of CPUs and better scalability, albeit at the cost of increased complexity.

Would you say then that we should not use server-side non-blocking processing if performance is not an issue? For the applications I work on, load is very predictable and low. It seems to me that in these cases the increased complexity is not worth it. (I contrast this to AJAX. AJAX enables web applications to do more work faster and responsively, but even if your web application has very little work to do, the user experience of AJAX applications is often superior to applications that do not use AJAX due to full page refreshes.)

Antón R. Yuste

Superb article, thanks!

user11017489

Thank you for this beautiful summary.

Re Lai-Oracle

Great article and project! I have a simple question. When you say:

Non-blocking request processing emerges as an effective way to address the problem. Instead of one blocking thread to handle one request, a small number of threads is used to handle a large number of requests asynchronously. This results in more efficient use of CPUs and better scalability, albeit at the cost of increased complexity.

Would you say then that we should not use server-side non-blocking processing if performance is not an issue? For the applications I work on, load is very predictable and low. It seems to me that in these cases the increased complexity is not worth it. (I contrast this to AJAX. AJAX enables web applications to do more work faster and responsively, but even if your web application has very little work to do, the user experience of AJAX applications is often superior to applications that do not use AJAX due to full page refreshes.)

Thank you. And yes, I'd think so. Asynchronous programming is harder to reason about.

lprimak

There is more hype in asynchronous / non-blocking programing than is proven by benchmarks or common sense:

Mohan Basavarajappa

Hi @"Yolande Poirier-Oracle"

informative article contributed. provides information on what all NIO frameworks are available and what is the high-level difference. More over it provides the advancements and where platform is headed. Nice samples too to get kick started with learning.

We are in the process of fixing the code layout. Sorry for the convenience.

Redfred Garett

Excellent article. Really very useful. Thanks !!!

1 - 8

Post Details

Added on Feb 9 2021
8 comments
265 views