Questions

I need help. I do I get data from the stats object in the JSON array using PL/SQL?<code>{"items": [{" stats": {"m_date": "2019-05-31T00:00:00","v_num": "0040012","pk_num": "0562","amt": 94,"bal": 75,"disc": 13}}}</code>Thanks...

I have some working SQL below that generates a row for each employee_id.My goal is to get every date in the range via the function, which works fine standalone, then get N ( random number ( 1-10) of rows for each employee_id for every in the range specified.O...

Hello,Oracle newbie here.I am getting this error "Character reference "&#56256" is an invalid XML character" for XML data that is printed onto a report. The XML data that is causing the issue is from a VARCHAR2 data column in the database. I have filtered out ...

Stats_mode function - Deterministic or Non- Deterministic? What does Oracle return when there are multiple keys with same mode (highest) and how? ...

Hello Tom !Is it possible to force Oracle to use (sub-)partition pruning when MEMBER OF operator is used on some nested table?For example:<code>SELECT * FROM A_TABLE WHERE COL_1 MEMBER OF NUMBER_TAB_TYPE(1,10,4);</code>where NUMBER_TAB_TYPE is defined as<code>...

I am using xmlagg function to concatenate records with comma separated values. But i am getting error when columns count is than 300 I getting below error <code>Error starting at line : 8 in command -select rtrim (xmlagg (xmlelement (e, COLUMN_NAME || ','))...

How should I use the EXPLAIN Plan for tuning of my SQL Statements .Kindly advice me on the sequence of steps to be followed . Some live examples could also be very helpful.With Regards.Ramesh.S ...

Product: Oracle Database 19c Transparent Data Encryption (TDE)From the Chapter 10 of Advanced Security Guide, we know for the supported block ciphers "table keys are used in cipher block chaining (CBC) operating mode, and the tablespace keys are used in cipher...

Hi ask tom team,I want to hide sensitive data when querying from SQL Plus or any other SQL tool (Toad, SQL Developer),but show data when accessing from application server.How can i do this ? preferably without physical access to database server (Remote Server)...

Hi,how to create view with parameter?we want to create view definition as below,<code>create view test_item_vas select item_class,nvl(rev_id,v_rev_id),sum(total_cost),sum(total_resale),sum(margin)from test_item_classwhere rev_id = v_rev_id;</code>Please sugges...

Tom:i try to use dbms_stats to give me a report ofwhat statistics is missing, what i do is:declare a dbms_stats.objecttab;begindbms_stats.gather_database_stats(OPTIONS=>'LIST EMPTY',OBJLIST=>a);end;after that how can i know the content of a? ...

Hi Tom,Is there a way to transfer a file from client machine to DB server using PL/SQL?If this is possible, can you show me an example?Thank you very much.Amy...

Hi, Tom.I am investigating a process of creating a transaction after a SELECT statement as a DML operator.Here is a steps,<code>COMMIT;ALTER SESSION SET ISOLATION_LEVEL = SERIALIZABLE; SELECT * FROM V$TRANSACTION;--Wait one minute to remember time of previous ...

Hi Tom/Team,I have installed Oracle 11g Database on my Windows 10 64-bit machine.All installation has been completed successfully. I have checked connections by sqlplus and it's running fine. I am able to run queries as well there. So database is working fine ...

Please help me keep my sanity by pointing me in the right direction when deciding the authentication approach to use with Oracle 19c databases. This is a very confusing topic since it deals with a few areas that require experience with Microsoft Active Direct...

Which are the important security steps to protect a databasewhose application will be in internet?Which are the differences between Connection Manager and Database Firewall?If I have native network encryption configured do I need to do somethingon application ...

Dear TOM!Is it save to use Flashback Query with views?<b>Setup:</b><code>CREATE VIEW my_view ASSELECT a.*, b.* FROM table_a a JOIN table_b b ON (a.ID = b.ID_A);</code> <b>Flashback Query at view level:</b><code>SELECT v.* FROM my_view AS OF TIMESTAMP sy...

Hi Tom,I am working on a datawarehoue project and using BULK COLLECT with SAVE EXCEPTIONS to log errors while loading data from source to destination tables. I loop through the BULK_EXCEPTIONS and insert the error_index and error_code with description into my ...

Hi Tom,Good DayI was reading a book written by a popular author (I would prefer not to mention the name of the book and its author). He says:In discussion on bitmap indexes, the following was written:"Concatenated B*tree indexes were being used and the distinc...

1) What the meanings of the event_name of "RMAN backup & recovery I/O", i.e. fetch the data from disk to PGA ？2) How to explain the bulk of "RMAN backup & recovery I/O" and "TIME_WAITED" with intermittently zero I/O value ？3) Why there would a non-zero value ...