Skip to Main Content

Questions

QuestionUpdatedAsked

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...
2 days ago3 weeks ago

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...
2 days ago3 days ago

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 ...
3 days ago11 days ago

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

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>...
3 days ago3.2 years ago

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 || ','))...
4 days ago3.6 years ago

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 ...
4 days ago21.2 years ago

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...
4 days ago3 weeks ago

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)...
5 days ago5 years ago

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...
6 days ago4 years ago

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? ...
6 days ago20.6 years ago

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...
6 days ago12.6 years ago

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 ...
9 days ago11 days ago

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 ...
9 days ago2.5 years ago

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...
9 days ago3 weeks ago

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 ...
9 days ago11 days ago

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...
10 days ago11 days ago

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 ...
11 days ago12.5 years ago

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...
11 days ago11.8 years ago

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 ...
13 days ago4 weeks ago