Throughout my career, I heard about Fine-grained Access Control (FGAC), Row Level Security (RLS), Virtual Private/Policy Database (VPD) and Oracle Label Security (OLS). These all sound very similar. I've only heard of OLS since it ...
I am reading a lot on AWR reports, and also posts about this subject.
But everyone say something different.
My client asked me for: "I want to know the I/O of the database"
Is there a metric, so I can execute a script on a time interva...
Iam exporting a simple select command into a csv file.
but the resulting csv file is incomplete ie. amon 44 columns it is displaying only 3 columns.
please find my code below,
set headsep on
set term off
set newpage 0
set space 0...
I'm a bit new to apex and I wonder if there is a way to check in apex, if new data was inserted in my DATA table.
I want to fire a dynamic action that refreshes the region only when new data has arrived.
For now, this works for me:
I am unable to connect to oracle database using SQL DEVELOPER but I am able to connect through windows cmd command. It gives me error i/o error network adapter could not establish connection. vendor code 17002. Please let me know what are the...
We have migrated data from SQL server to Oracle,As part of data validation we want to compare the data from both databases. We have some tools which compare data but that tool will not compare lob columns.
Please note we had migrated dat...
I posted this problem elsewhere and we had a bit of a discussion. However I would like to know whether what we see is a feature (i.e. it can be relied upon to be somewhat consistent in future releases) or whether it is a "featurette" - i.e. unintende...
I'm new to Oracle Application Express and currently working on an APEX application.
We have several reports which can be downloaded as csv files in various modules of the application.
What I need is to have a master report(excel file with ...
I'm in need to encode and decode big xml, however when i'm decoding from base64 after some iterations it fails to decode and i get symbols like this, "S??FS???S??FS???S?". Here's the script to reproduce the problem i'm facing:
I have a set of 3 tables that are reference partitioned (a parent and two child tables). The parent table is range partitioned by date (TST_ADM_DTE) and contains 1,152 partitions, ranging in value from 3/1/14 to 12/31/16. The first seven (7) partitio...
I have a query which i am trying to load the data using 2 options:
1. Materialized View Refresh with Non-Atomic Refresh
2. Insert into Select
Materialized View Refresh: When i try to Complete refresh a Materialized View in 12c Database...
I have done installation of GI for standalone and oracle database, with different OS user.
Now, I want to remove GI software only as I am not using ASM for datafiles.
Can I able remove only GI with deinstall utility. I donot want to re...
dbms_session.unique_session_id returns unique value for my session. understood.
but the question is - what information can i gain from it? how or where i use the returned value?
are there any dba or system tables where i can: select * from tabl...
I have been working on JSON features in Oracle to extract field values from the Clob & came across one question - Is it possible to extract the number of elements in the JSON data ?
Ex: If i have below the JSON , is it possible to get the...
I'm trying to create a SQL statement with a condition in the WHERE clause that will deliver all results that start with 3 letters.
The column type is varchar, and all entries either look like 'ABC123' or 'A12345'.
I'm not looking to retu...
Hi Tom and Team,
I have a SELECT query that runs fine if submitted the 1st time (takes about 3 seconds), but if I submit it right after again, it could take anywhere from 22 to 37 seconds (on a pretty consistent basis). If I wait a few hours (or ...
What are the things that result in FULL TABLE SCAN?? Thanks in advance...
Does archive of redo logs get completed when STATUS of redo log is active ? and what happens when STATUS of redo log is inactive in background ?
Scenario that i tried
Three groups of Redo log size 50mb each and Archiving is Enabled and insert...