1. Write a query to display all the fields of the ' bill'  whose payment is not completed. Display the records…

declare   2  x number(3);   3  y number(3);   4  z number(3);   5  procedure pp(m IN number , n IN number , o OUT num…

declare   2   Tes string(20) := 'VardhanRaju';   3  begin   4  dbms_output.put_line(instr(tes,'r')); …

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 …