pl | A collection of javascript helpers

What's the use of call dbms_scheduler.auto_purge()? The procedure is not listed in the official PL/SQL Packages and Types Reference.

When I execute this function, what will happen?

I wanted to get started with posh and oh-my-posh so I installed them according to this article. Microsoft docs. I got the theme but the edges didn't had that arrow(that coolness).

I then downloaded the windows terminal and edited the setting.json there with

Following script is a combination of RSI and Higher High and Lower Low script. The issue is that the HH LL labels are aligned for the price not on the RSI Line. How to align the labels to the RSI line? It is basically showing the Higher Highs and Lower Lows of RSI. The labels need to stick on to the respective RSI line.

Good day, I am trying to create a trigger that should retrieve the total number of users based on their job category (medic/other) into two parameters for all users who have registered so I developed:

I have difficulties to find the right regex under PL/SQL, but my regex is normally good

I have a phone number like this :

+44 (0)22 3333 4444 from the text that should not be there

And I want to get this:

+4402233334444

So I made the following regex:

/[^+\d]|\s/g

It works very well on the site https://regexr.com/ but not in my PL/SQL query, it gives me the same result

I tried to use the oracle doc, but without success https://www.techonthenet.com/oracle/regexp_like.php

This is my script count.pl, I am trying to count the number of lines in a file. The script's code :

I have master-slave (primary-standby) streaming replication set up on 2 physical nodes. Although the replication is working correctly and walsender and walreceiver both work fine, the files in the pg_wal folder on the slave node are not getting removed. This is a problem I have been facing every time I try to bring the slave node back after a crash. Here are the details of the problem:

postgresql.conf on master and slave/standby node

Good day,

I am trying to create the below procedure that will update a table (annouce_form) based on a job category, plus I would like to know if it is possible to include multiple update commands in one procedure:

I'm trying to develop a perl script that looks through all of the user's directories for a particular file name without the user having to specify the entire pathname to the file.

For example, let's say the file of interest was data.list. It's located in /home/path/directory/project/userabc/data.list. At the command line, normally the user would have to specify the pathname to the file like in order to access it, like so:

cd /home/path/directory/project/userabc/data.list

Instead, I want the user just to have to enter script.pl ABC in the command line, then the Perl script will automatically run and retrieve the information in the data.list. which in my case, is count the number of lines and upload it using curl. the rest is done, just the part where it can automatically locate the file