MySQL Workbench, Git, and Misc
Mar 29
Grid
MongoDB: Array Operations
Try these Array Operations: db.posts.find({}, {_id:0, category:1, tags:1}); db.posts.updateMany({category:'Event'}, {$addToSet:{tags:"Tech"}}); db.posts.updateMany({category:'Event'}, {$push:{tags:"Tech Event"}}); db.posts.updateMany({category:'Event'}, {$pull:{tags:"Tech"}}); db.posts.updateOne( { likes: 4 }, ...
Try: MongoDB Regular Expresssions
^ : starts with $ : Ends with .* : any char, any number of times /i : case insensitive ...
Oracle Auditing
To Know: •WHAT IT IS? •WHY WE NEED •WHAT CAN WE AUDIT •WHAT ORACLE AUDITS ON Its OWN •WHERE AUDIT ...
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) ...