Jan 29
Dynamic/Ref Cursor CREATE OR REPLACE PROCEDURE query_invoice( month VARCHAR2, year VARCHAR2) IS TYPE cur_typ IS REF CURSOR; c cur_typ; query_str VARCHAR2(200); inv_num NUMBER; inv_cust VARCHAR2(20); inv_amt NUMBER;BEGIN query_str := ‘SELECT num, cust, amt FROM inv_’ || month ||’_’|| year || ‘ WHERE invnum = :id’; OPEN c FOR query_str USING inv_num; LOOP FETCH c INTO …
Jan 19
Write a SQL block that will categorize Employee Salaries. If the Salary is higher than average, it will show ‘Above Average’ to the output. If the Salary is lower than the average it will show ‘Below average’ to the output. Use HR.Employees Table. Also, utilize CASE statement.
Jan 15
Ref: https://trivadis.github.io/plsql-and-sql-coding-guidelines/v4.1/2-naming-conventions/naming-conventions/
Jan 12
Visualizing 3-D numeric data with Scatter Plots length, breadth and depth Ref: https://towardsdatascience.com/the-art-of-effective-visualization-of-multi-dimensional-data-6c7202990c57 import pandas as pdimport matplotlib.pyplot as pltfrom mpl_toolkits.mplot3d import Axes3Dimport matplotlib as mplimport numpy as npimport seaborn as sns%matplotlib inline fig = plt.figure(figsize=(8, 6))ax = fig.add_subplot(111, projection=’3d’) xs = wines[‘residual sugar’]ys = wines[‘fixed acidity’]zs = wines[‘alcohol’]ax.scatter(xs, ys, zs, s=50, alpha=0.6, edgecolors=’w’) ax.set_xlabel(‘Residual …
Jan 12
Ref: https://www.ibm.com/docs/en/tnpm/1.4.5?topic=tasks-disable-selinux-linux-only Sample File:
Jan 12
getsebool -a | head abrt_anon_write –> offabrt_handle_event –> offabrt_upload_watch_anon_write –> onantivirus_can_scan_system –> offantivirus_use_jit –> offauditadm_exec_content –> onauthlogin_nsswitch_use_ldap –> offauthlogin_radius –> offauthlogin_yubikey –> offawstats_purge_apache_log_files –> off
Jan 08
Options: Cisco Any Connect Cisco Mobility Connect You will be able to download from: https://software.cisco.com/download/home Versions available for Windows, Mac, and Linux. Other Options: OpenConnect Global Protect NordLayer Using Anyconnect VPN on Linux: https://www.cisco.com/c/en/us/support/docs/smb/routers/cisco-rv-series-small-business-routers/kmgmt-2597-Installing-AnyConnect-Linux-Ubuntu-desktop-User-Interface.html Open Connect: https://www.infradead.org/openconnect/download.html NordLayer Business VPN: https://nordlayer.com/business-vpn “A VPN is a security solution that provides a tunnel between your organization’s resources …
Jan 05
How to fix mail command does not work? yum install mailx or apt get install mailx
Jan 03
•To get some details on MVC pattern, you may want to check: •https://www.javatpoint.com/mvc-architecture-in-java •https://www.geeksforgeeks.org/mvc-design-pattern/ •An MVC Web Application (approach, minimum what we want) •https://www.baeldung.com/mvc-servlet-jsp Java Spring MVC: Learn to do it Step by Step in Eclipse https://www.digitalocean.com/community/tutorials/spring-mvc-example Ref: the link above IntelliJ: Spring MVC •https://medium.com/panchalprogrammingacademy/create-a-spring-mvc-project-with-maven-and-intellij-idea-community-edition-1d31b3efe078 Java Spring MVC in Eclipse •https://www.digitalocean.com/community/tutorials/spring-mvc-example
Jan 02
Ref: Google Images If you have Access to Linkedin Courses: You can read from: It explains the diagram below i.e. how the adapter pattern works: Explained the Diagram : https://www.linkedin.com/learning/programming-foundations-design-patterns-2/the-adapter-pattern-defined?autoSkip=true&resume=false&u=2199673 Check the code from here: https://www.tutorialspoint.com/design_pattern/adapter_pattern.htm A video example: The above will be easy to understand https://www.linkedin.com/learning/programming-foundations-design-patterns-2/using-the-adapter-pattern?autoSkip=true&resume=false&u=2199673 Using MediaAdapter, AudioPlayer is accessing the methods of …
