Recent questions tagged oracle12c

0 votes

2.0k views

1 answer

oracle12c - Oracle Materialized View with ENABLE ON QUERY COMPUTATION

I am trying to create the following Materialized View with ENABLE ON QUERY COMPUTATION but I can't find ... /65886023/oracle-materialized-view-with-enable-on-query-computation...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

316 views

1 answer

oracle12c - Oracle 12c - Find if temporary objects created before TEMP_UNDO_ENABLED is set

Database : Oracle 12c (12.1.0.2) - Enterprise Edition with RAC I'm trying to reduce REDO and archive logs ... 12c-find-if-temporary-objects-created-before-temp-undo-enabled-is-set...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

610 views

1 answer

oracle12c - PLSQL Oracle SFTP Connection

Is there any way to transfer data through SFTP using oracle PlSql. I found many exmaples with FTP ... https://stackoverflow.com/questions/66047351/plsql-oracle-sftp-connection...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

418 views

1 answer

oracle12c - How can I change default role in Oracle Database

Due to the audit security, If I wouldn't revoke the privilege from the public role can I change the default role in ... it to create under the new default? Thanks and Best Regards,...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

416 views

1 answer

oracle12c - Adding days to the select query result dates in oracle

select from_date_su_rela,to_date_su_rela from RELATION_T; But the expectation is reducing -56 days from the first row from_date_su_rela ... to make it working as above 2nd image....

asked Feb 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

471 views

1 answer

oracle12c - Oracle SQL data migration based on start and end date

Working on migrating old system data to new system. I need to group the data based on id and name. We need to ... Please let me know if more details needed. Thanks in advance....

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags