insertion in a table of objects with nested table in oracle
I have a problem inserting in a nested table in oracle
oracle-11g
Oracle 11gR2 – Expdp Full Database With Exclude Some Table Data
We will migrate our database using datapump.
Select multiple columns from subquery – Connect by
I have a table which manages folder structure. Hence it has a parent-child relationship. We trigger a query to sum all documents in the complete heirarchy:
Oracle 10g dump file push into Oracle 11g database
Currently when executing the imp command with the following parameters: file=my.dmp log=my.log fromuser=myuser touser=myuser
Rename interval partitioning system generated partition names
I have an existing table which I partitioned (interval partitioning on a daily basis) using dbms_redefnition.
Oracle 11.2: Backup and recovery strategy based on full cold backup plus expdp
Are there any issues with the following strategy for backup/recovery in Oracle 11.2.0.4?
How do I include zeros in a count(column)?
I am attempting to build a report for a client. I need a display of all the values in Tab1, Col1 (a validation table), a count of each time that occurred, and a percentage of the total. Here’s what I’m looking for:
Oracle: How can I create a where clause programmatically?
Suppose I have a table like:
Oracle database won’t start, ORA-03113
Running Oracle 11.2.0.4.0 on CentOS and discovered the hard drive filled up, giving error in alert log:
Fetch all rows and leave column value empty if no equality match
I have a query where I want to fetch all rows where the value in column x is between 400-600.
Including in this I want a matching column value from antoher table.