insertion in a table of objects with nested table in oracle
I have a problem inserting in a nested table in oracle
oracle
Oracle Clusterware – What is the difference between Votedisk, quorum disk and quorum failure group?
Some references say quorum disk and vote disk are the same, but “quorum disk” name was used in older versions. But Oracle 19c documentation still use both the names, so I think there is a difference. Also, when to use quorum failure group and what is it? documentation says:
I have a table where where each project_id generates multiple rows
My table below shows the rows and columns where the column data is filtered using a CASE syntax to differentiate capital from expense. The problem is I am getting multiple rows per project_ID.
I need one row per project_ID:
Oracle 11gR2 – Expdp Full Database With Exclude Some Table Data
We will migrate our database using datapump.
understanding oracle pluggable databases
I’m learning a little bit about Oracle Database. As I understand:
Oracle: I drop a table, but select still show it
I see today a strange thing on my oracle db.
Oracle: a litte confused about privileges granted to my user
I want to give few permission to my non-dba user on my database.
I give create session, create table, view, etc..
This query seems to confirm
Problem with Oracle Job Scheduling
I have a job that refreshes a materialised view refresh group on Oracle 19c. I wanted to refresh the group daily at midnight – trunc(sysdate)? The job was made using using the following PL/SQL:
Get explain plan for query with inline function
I have a query that has an inline function:
Query to update one column based on the amount of another column
I have a table with below structure :