Security is of great concern today.Here are the steps Enabling SSL in Oracle Apps R12 Introduction: The data between web browser and web server travels unencrypted in R12 application So the password and other information can be tracked by sniffer. They can get your Username/Password or any sensitive data. This become critical when you have Internet access …
Enabling SSL or TLS in Oracle Apps R12 Read More »
Introduction to Enabling TLS in R12.1 The data between web browser and web server travels unencrypted in R12 application So the password and other information can be tracked by sniffer. We are avoiding this by implementing TLS in R12. With TLS implementation, the data travels in the encrypted forms and Only web browser and web …
We have already read about the Oracle cursor in the below post What is the cursor in oracle Let’s check about the select for update oracle. How it is beneficial and How to use it in PLSQL For Update clause of Oracle Cursor (1) For Update Clause can be used within the cursor query. This means …
DBA’s or the Developer often need to list various tables in oracle. They would require to List All Tables in Oracle for Audit and security purposes. Sometimes they want to List All Tables in a particular tablespace or particular schema or sometimes to list all the tables which are created recently. We would be showing …
Here are some of the Top Oracle data guard queries/physical standby database queries for monitoring and troubleshooting How to check the archive log sequence on Primary Side SELECT THREAD# “Thread”,SEQUENCE# “Last Sequence Generated” FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#) ORDER BY 1; How to check the archive log …
Constraints are the ways to enforce data integrity rules in the Oracle database. If we dont require constraint at any point in time, we can drop constraint in Oracle using the alter table command. Let’s check with the addition of constraint and then drop them Oracle Table creation and Constraint creation SQL> CREATE TABLE “DEPT” …
How to drop constraint in Oracle Read More »
