Skip to Main Content

Questions

QuestionUpdatedAsked

Hello,It would be great if you can help me here.Can you please share if Oracle has any feature similar to the "Always Encrypted" feature offered by SQL server? Link pasted at end has information on "Always Encrypted".I understand that Oracle offers data redact...
5 hours ago17 hours ago

I have a table tb_card_dataCARD_NO TYPE EMAIL MODULE CREATED_ON SEQ_NO------- ---- ----- ------ ---------- ---------12345 C x@a.com MOD_1 06/03/2017 20170306000001 (create_on + sequence number)..so on around 500k records for MODULE - MOD_1around 500k...
6 hours ago3.4 years ago

I am trying to get the currval of all the user sequences in the schema. When I run the below sql it gives me invalid sql statement.I am not sure if the below is the right way to achieve it. Please advise.Assumption: The current value of the sequences are alrea...
6 hours ago24 hours ago

Hello, Tom.We have a fact table, that is partitioned by day and stores the last 90 days of data. Sometimes users of the application can change the status of record from 'ACTIVE' to 'CANCELED'.There are a lot of heavy analytical queries against that table that ...
8 hours ago6 days ago

i want to make rankning of trucks exit based on break more than 1 hourlike eg belowTRUCK EXITT1 10:00 PMT2 10:05 PMT3 12:00 PMT4 12:05 PMT5 12:10 PMT6 12:20 PMResult should be like...... leaving break more than 1 hours gaps10:00...
9 hours ago17 hours ago

Hi,I am currently working on developing apex web application which requires to capture CLOB data and save it to DB.I am using Rich text editor to capture the content and noticed that only max of 32k characters can be loaded through the page item.when I try to ...
13 hours ago6 days ago

Environment: Oracle 12.1.0.2 on Exadata I have a table with 30 columns, one of which is a CLOB, that contains about 26 million rows. I have a purge job (PL/SQL packaged procedure) that DELETEs rows from nine (9) other tables based on a list of IDs from the dri...
13 hours ago6 days ago

Hi dear AskTOM team. Have a great day to everyone. I have some confusion about UPDATE TABLE statement in Oracle DB 12cr2. Let's assume we have 3 users: U1; U2; U3;U1 has a table called TEST_1, and U2 and U3 both have UPDATE privilege on that table.My ...
14 hours ago30 hours ago

export is done on table level using 9.2.0.1exp user/password tables=emp,foo file=test.dmpduring import sequences never got imported. This is the default behavior of oracle. I would appreciate if you please advise on the followings:1. How to import sequences i...
19 hours ago17.8 years ago

Hello Everyone,There is a table(xxln_vs_publish_stg) has xmltype column(xml_data) which stores XML data. I have a requirement to convert XML data to json data.For that, I am using apex_json.write to convert. While executing below logic for changing it, I am ge...
19 hours ago4 days ago

I'm observing the following with regards to PLSQL_CCFLAGS and "AFTER LOGON ON DATABASE" triggers:* Compiled PLSQL_CCFLAGS setting is not honored* Code that runs is not necessarily what is shown in dba_plsql_object_settings* Doesn't matter if the trigger is own...
19 hours ago3 days ago

Hi,We are migrating our 7TB oracle database to another server . It would consist of upgrade from 11g tp 12c .Could you suggest of anyways where we can make sure that all the queries in the target database picks the same plan as before?Thanks....
32 hours ago33 hours ago

Hi Tom,There is a process of nightly Load every day which is scheduled so we have Materialized view (aggregation are there in MV base on some table) which is refreshed daily as a 'complete' refresh.so as the data grows daily so the performance of complete refr...
32 hours ago36 hours ago

Hi Team,We are having PeopleSoft systems connected with Oracle 11.2.0.4 database. We have monthly financial close activities every beginning of month and lot of jobs use to run as part of this which internally access multiple large records.We have a database o...
43 hours ago4 days ago

Hi Tom,I have got primary/standby setup manually without Data Guard. The 2 instances are running on different Linux servers - same file system configuration. The archive logs are copied and applied from primary to standby by scripts regularly.What is the corre...
43 hours ago4 days ago

Suppose Global temporary table used in procedure that is call my_proc();My problem is while developer modify procedure code and its compile the same procedure while parallel running same procedure by client.And sometime takes to much time to complete execution...
43 hours ago4 days ago

Hi,Thanks for your time and effort.I want to connect my home computerTo my office computer where the oracle database located.How can I connect through internet....
43 hours ago3 days ago

Hi, I have an question if it's possible to parse json which i posted in livesql to table which columns:foo,let,letID. Eventual if it's some convenient way of queering for letID and foo at the same time. I've tried to do it in that way: <code>select *from examp...
44 hours ago1.1 years ago

Tom:1. I had a problem with a date query using the operator 'between'.WHen I doSelect * from table where date is between '01-JAN-02' and '17-JAN-02'it does not give me the records marked with a date '17-JAN-02'I have to change it to '18-JAN-02' to get those....
45 hours ago18.5 years ago

This function DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS copy the dependent objects of the base table into interim. What is the use of it? And what will happen if I do not run this step?...
4 days ago4 days ago