SQL> set serveroutput on SQL> declare   2  i number(3) := 1;   3  begin   4  loop   5  DBMS_OUTPUT.PUT_LINE(i);…

SQL> SET SERVEROUTPUT ON SQL> Declare   2  name varchar(12);   3  sub1 number(4,2);   4   sub2 number(4,2);   5 …

Distinct -> no duplication Dual -> dummy table which has only one row & one column used for math expression…

IN: group of values we have to search NOT IN: opposite to in. Between: it will search between specific condition. not …

DDL:(DATA DEFINATION LANGUAGE) 1.CREATE( TO CREATE NEW DATABASE) 2.ALTER(FOR MODIFYING ON EXISTING OBJ) 3.TRUNCATE(TO …

import  java . util .*; public   class  Main {      public   static   void  main ( String []  args ){                …

import  java . util . Scanner ; class  Main  {      public   static   void  main ( String []  args )   {         Scan…