creating a view create view rahul_emp_details as select e.empno,e.ename,e.hiredate,d.deptno,d.dname from rahul_emp e,rahul_dept d where e.deptno = d.deptno create instead of trigger on th...

triggers create trigger on rahul_emp_del when deletion occurs on rahul_emp create or replace trigger rahul_emp_del before delete on rahul_emp for each row begin insert into rahul_emp_histo...

This article is my take on an Artificial Neuron or Perceptron. A lot of jargon has been skipped to make concepts easy to understand (or so I believe :p). Since Logic Gates are easy to solve so I ...

“Spark Framework is a simple and expressive Java/Kotlin web framework DSL built for rapid development.” A quick look on sparkjava.com and you will see how easy it is to use, it literally takes a f...

packages creation create or replace package rahul_salary as procedure rahul_process_increment; function rahul_fn_increment(phiredate rahul_emp.hiredate%type , psal rahul_emp.sal%type) return ...

Imports import com.fasterxml.jackson.annotation.JsonInclude.Include; import com.fasterxml.jackson.databind.DeserializationFeature; import com.fasterxml.jackson.databind.ObjectMapper; import co...

create function create or replace function rc_increment (phiredate rahul_emp.hiredate%type , psal rahul_emp.sal%type) return number is service_yrs number; revised_sal rahul_emp.sal%type ; beg...

procedure declare create or replace procedure rahul_increment_emp (phiredate rahul_emp.hiredate%type, psal rahul_emp.sal%type, incr_sal out rahul_emp.sal%type) is service_yrs number; Begin s...

exception declare msal rahul_emp.sal%type; mempno rahul_emp.empno%type; mename rahul_emp.ename%type; mjob rahul_emp.job%type; begin mjob:=upper('&inpJob'); mempno:= &inpEno; s...

record creation declare Type emp_info is Record ( empno emp.empno%type, ename emp.ename%type, hiredate emp.hiredate%type, sal emp.sal%type ); mrec emp_info; mempno emp.e...