Questions

Before understand question mind I have one table with 3 columns one is id second is description and third is sql query, i created one Apex page with two region one is static region and one is Interactive Report Region. In Static region i have one select list ...

I'm trying to create a database link using the <b>CONNECT WITH</b> clause that's mentioned in the documentation for CREATE DATABASE LINK so that I can use a database credential in the DDL statement.The doc I'm referring to is : https://docs.oracle.com/en/datab...

Hi all,I have a problem with liveSQL. I can't create a sharable link. Even with FreeSQL, can't do so. Appreciate any help.Thnks...

When querying a mounted database, an ORA-01219 occurs when querying anything besides instance views such as v$database. This is even the result when using a WITH clause that, itself, is an allowed query for a mounted database. For example:<code>SQL> select sta...

To avoid unexpected execution plan changes some people say that we must set DBMS_STATS estimate_percent should always be to 100.I would like to know if you agree with this ?...

<u></u>table has two rowsselect id,value from IIO_SYSTEM_PARAMETER;200 1027/1029/1000199 1027/1029/1000when I ran the below query, it is giving 7 records, instead of 3 records<b>query1:</b><code> SELECT REGEXP_SUBSTR(VALUE, '[^/]+', 1, LEVEL) DEST ...

Hello,I work as a dba and get requests from developers to create tables which we often review and sometimes change for better design and/or implementation.One of the developers recently sent a request to create a table such as the following ;table_name:t1_rela...

How to activate the auto-index feature in Oracle 19c Enterprise Edition?To activate on PDB send me the error:<code>BEGIN dbms_auto_index.configure('AUTO_INDEX_MODE','IMPLEMENT'); END;Informe de error -ORA-40216: función no soportadaORA-06512: en "SYS.DBMS_SYS_...

Hi Tom,First of all, I want to thank you for all the things which you have done and doing for Oracle community. It inspire me to learn more and more.Now my question is --Is there any way by which we can hide the procedures and functions code so the user can on...

Hi,I have created an application that is tracking a set of processes that are being run from a master table. When a process is completed, a flag in a column name PROC_EXEC_STATUS changes from N to Y for each process. I want my oracle apex application to refres...

I have PL/SQL package with a function that returns a list of item numbers. This package/function is repeatedly called by online with multiple users; passing parameters to the function to use within the SQL statement(s). A new string (short list of item types) ...

<u></u><u><b>We are building a system where:</b></u>- Application users connect using different DB users- They call DBMS_SCHEDULER.CREATE_JOB to create jobs- Jobs are always expected to execute in the application user(APPUSER) schema- We call external C++ func...

I have recursive query on Oracle 11g table with undirected graph data. Each row represents one edge. The recursive query traverses all edges starting from given input edge. The idea of query is: - input edge is at the 0th level- for n>0, edge is on n-th level ...

Tom,I have been trying to understand the concept of redo log threads in a RAC environment. I understand how the redo logs work in a single instance database. But I cannot find proper documentation anywhere that clearly explains what a redo log thread is and ho...

We start getting alerts about a tablespace users that it was getting full, tablespace users contains 3 datafiles of 32GB each, but we found out that in one of the tables in tablespace users it has a Lob(67 GB), so we decided to moved that Lob to have it owns t...

I have a problem in defining shared folders in VMVirtualBox.As there ist no category for that it seams that this is the wrong place.So where can i send the problem that seems to be a bug?...

hi folks,I am very happy about the new enum domains in PL/SQL. They are very useful and can make the code much more maintainable.But I struggled over a problem. When I create an enum domain like <code>create domain MY_TEST_ENUM as enum ( text1 = 'text1', tex...

With Always Free, there is no support. How do I get DBMS_CRYPTO grant? I tried using STANDARD_HASH, but it says STANDARD_HASH must be declared. So is there a way to get this access preferably to DBMS_CRYPTO? If not is there an alternative?...

Refer to object-relational-developers-guide / Column Object Storage in Relational Tables If “The null indicators for an object and its embedded object attributes occupy one bit each. Thus, an object with n embedded object attributes (including objects at all ...

كيف يمكنني الحصول علي كتب عن تطبيقات APEX? اريد ان أتعلم منها أثناء التجربه وتكون مساعدا لي في التعليم ...