plsql

There are three tables linked one-to-one by ID. I need to delete all records from three tables that satisfy the condition: A. ... D LOOP; COMMIT; END; There is a lot of data and so it works for a very long time. Is there any way to make it faster?

In SQL Server, you can use the function IsNull(expression, replacement), to determine whether the result of the expression is NULL, and replace it with an alternative value in this case. Is there an equivalent function IsNull() in Oracle?

You need to prevent deleting records from the table that do not meet a certain condition by using a trigger. Without using th ... re some options can be deleted, but the rest can't, the trigger immediately throws an exception and does not delete anything.

How to fix this error: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GET_DATA_INFO' ... ptions); Free translation of the question PLS-00306 when calling Oracle stored procedure in Node.js from member @siddhartha

How do I make a query that returns a conditional chessboard image? The column headings must contain the Latin letters a,b,c, ... ution is not correct, but I have not yet come up with another one. How can I display a chessboard and fill it with 1s and 0s?

The question arose, what is the easiest way to import a PDF to the columnBLOB? I thought to implement this logic: import BLO ... ze, dest_offset => l_dest_offset, src_offset => l_src_offset); DBMS_LOB.fileclose(l_bfile); COMMIT; END;

There is a code that returns an error message if the value is invalid. I would like to return an error message if the given ... ue>7200000)) THEN ... Free translation How can you tell if a value is not numeric in Oracle? from member @Kyle Williamson

There is a table: CREATE TABLE table ( start_range varcahar2(10), end_range varcahar2(10), val_range NUMBER(10) ); At ... erent table table2 with rows in the range between start_range and end_range? To make it look like this: (a1, a2, a3, a4, a5).

By analogy with the output of the function result: SELECT * FROM TABLE(пакет.функция(параметры)); What if we have a proced ... CURSOR, другие In параметры ) How do I get the same selection directly in the SQL Window as in the case of the function?

CLOВ stores the request in XML format along with the preamble: POST:... Cache-Control: no-cache Connection: keep-alive ... SO ... cessing LPX-00210: expected '<' instead of 'P' Error at line 1 ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: at line 1

What is the correct and proven way to check for an entry in a table when using a PL / SQL block? For example, there is a tabl ... to check. Free translation of the question Proper way of checking if row exists in table in pl/sql block from member @devBem

Partitioned table created with automatic partitioning (range, interval-1, key-number) partition by range (gr_id) interval (1 ... Can I in this case do you want to use automatic partitioning, or do you have to hard-code all partitioning for single values?

I found very little information about such objects as "domains". I know it's about (). Translation: What is domain type in ... I often find domain declarations in it. But in fact, in the database I do not see them as objects, or mentions in the code.

In the Oracle DB releases prior to 19c, the SYS_CONTEXT('USERENV','BG_JOB_ID') function returned the job ID (column user_job ... ried to link through the views v$Scheduler_Running_Jobs and dba_jobs_running. You can do this, but I'm not sure what's right.

After migrating to Oracle 18c Enterprise Edition, creating a functional index (FBI) fails. This is what DDLs look like for c ... c? If such a feature is no longer supported for the FBI, what other way is there to provide such functionality for the index?

In which tasks do I need to use cursors at all: explicit or implicit? In the book Oracle PL / SQL For professionals in the 15 ... Explicit cursors for the same type of repeated queries What is for implicit? And what is meant by the same type of requests?

Some parts of the package use insert into select from, and some parts use insert into select from.- bulk collect + forall ins ... view, does one of these methods have an advantage in speed or other aspects of execution, or are they completely equivalent?

Closed. It is impossible to give an objective answer to this question . Answers to it are not accepted at the moment. ... tools (programs) that make life easier for the developer? P.S. Preferably free products, since the workstation is corporate

ORA-00600: internal error code, arguments: [qcsfbdnp:1], [B14], [], [0], [], [], [], [], [], [], [], [] ORA-06512: at "IJJ_D ... u cut the select query from the code and run it simply in sql developer, it works without problems. Oracle version 11.2.0.3.0

I can't win. You need to pull out everything that is between the tags. It turns out to pull out only what is before the line ... ect regexp_substr('<message>aaa bbb ccc </message>','<message>(.*)</message>',1,1, 'n') from DUAL