Skip to Main Content

Questions

QuestionUpdatedAsked

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...
43 minutes 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? ...
2 hours 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...
3 hours ago12.6 years ago

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...
5 hours ago2 weeks 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 ...
3 days ago5 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 ...
3 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...
3 days ago2 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 ...
3 days ago5 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...
4 days ago5 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 ...
5 days ago5 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 ...
5 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...
5 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 ...
7 days ago3 weeks ago

Dear Tom,Is it possible to analyze <compute option> only a partition of a table. <using DBMS_STATS package> i want to analyze a table <table having 83 million rows> parallely. when using ANALYZE table command for estimating statistics it is taking 90 minutes <...
7 days ago20.3 years ago

1) I installed Oracle18cXE on my local pc.2) I have installed instant client on my pc3) Configure wallet of my Autonomous account. I take backup from my autonomous account using version=11.2.2 and import on my local instance on XE.4) It is not restoring gives ...
7 days ago6 months ago

Hello ,i want to have multiple value per cell and i used nested tables.After creating my table projects with a the nested column categories, i insert some rows. but when i do select * from tables , i have the error unsupported data type by the column categorie...
10 days ago4.4 years ago

I have created a typebelow is the code of the type<code>create or replace type tt_name as table of varchar2(250);</code>Now I want to perform select on this type in a plsql codeselect listagg(column_name,';') within group(order by column_name) into varchar_var...
11 days ago4.8 years ago

The requirement here is to Query Spatial Data, I want to know which Latitude and Longitude inside one VERTICE(An Array).-->tmp_notam_tfr-> I have all vertices Latitude and Longitude Data per NOTAM_ID in one row.--VERTICE DATA-->EXPORT_TABLE -> I have Tower's D...
11 days ago2 weeks ago

Dear AskTom,I have a shell script that connects as several different users to the same database.From Oracle:You can store multiple credentials for multiple databases in one client wallet. You cannot store multiple credentials (for logging in to multiple schema...
11 days ago1.7 years ago

Hey guys, Running a 2 node RAC and I’m trying to utilize parallelism for backups but I’m not having any success. When I monitor gv$session_longops I see sessions on both instances but there are like 2 sessions from instance x and the rest go to instance y. Won...
11 days ago3 weeks ago