May 20
Grid
Oracle pfile, spfile
Ref: https://www.devopsschool.com/blog/oracle-tutorials-what-is-pfile-and-spfile/ ...
Oracle : Auditing Database Activity
7 Auditing Database Activity This chapter contains: About Auditing Why Is Auditing Used? Where Are Standard Audit Activities Recorded? Auditing ...
Connect to Sql Server FROM JAVA
https://learn.microsoft.com/en-us/sql/connect/jdbc/connection-url-sample?view=sql-server-ver16 import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class ConnectURL { public static void main(String[] args) ...
Oracle: Hierarchical Queries and Advanced Analytics Functions
•Hierarchical Queries •START WITH •CONNECT BY PRIOR •CONNECT BY FOLLOWING •ORDER by level •Analytics Functions •Windowing •PRECEDING, UNBOUNDED_PRECEDING •ROWS BETWEEN ...
PL/SQL Function Syntax in Oracle
REF: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/CREATE-FUNCTION-statement.html ...