Boxode

 ● Que1 :-Create following table :- 1.create employee table.  Eg. Create table employee(Eno integer primary key, Ename varchar(10), job        Varchar(10), Mgr_no integer, Jdate  date, Sal integer, comm integer, Deptno Integer,foreign key(deptno) references dept(deptno)); 2. Create Dept table. Eg. Create table dept(deptno integer primary key, dname varchar(10), Location Varchar(10));                                                                   3. Insert record in employee table. Eg. Insert into employee values(7369,Smith,Clerk,7902,1980-12-17,800,--,20); 4. Insert record in dept table. Eg. Insert into dept values(10,P.A,Bangalore); 5. Find the name of all employee having L second letter in their name. Eg. Select name from employee where ename like _l%; 6. Find the list of employee...

 Full course of c++ programming language Click here >  C++ programming language ========================================= 1]Write a PL/SQL block for insertion into table EMPDEPT table with thefollowing. Calculations: HRA= 50% of BASICDA= 20% of BASIC PF= 7% of BASIC NETPAY= BASIC + HRA + DA + PF EMPDEPT (ENO, ENAME, DEPTNO, BASIC, HRA, DA, PF) SQL> create table Empdept   2 (Eno number primary key,   3 Ename varchar(20),   4 Deptno number,   5 Basic number,   6 HRA number,   7 DA number,   8 PF number,   9 Netpay number); Table created. set severoutput on declare  Eno number:=&Eno;  Ename varchar2(20):=&Ename;  Deptno number:=&Deptno;  Basic number:=&Basic;  HRA number:=Basic*0.5;  DA number:=Basic*0.2;  PF number:=Basic*0.07;  Netpay number:=Basic+HRA+DA-PF; begin  insert into Empdept(Eno,Ename,Deptno,Basic,HRA,DA,PF,Netpay)values(Eno,Ename,Deptno,Basic,HRA,DA,PF,...

Full course of c++ programming language Click here >  C++ programming language ===================================== 1. Write a program to display an average of 3 inputted numbers. a=int(input("Enter a : ")) b=int(input("Enter a : ")) c=int(input("Enter a : ")) avg=(a+b+c)/3 print(avg) ====================================== 2. Write a program to calculate simple interest for a given principle amount, rate of interest and no of years. p=float(input("Enter a P : ")) r=float(input("Enter a R : ")) n=float(input("Enter a N : ")) si=(p*r*n)/100 print("simple interest is ",si) ====================================== 3. Write a program to display area of triangle. base=float(input("Enter a base : ")) height=float(input("Enter a height : ")) area=base*height/2 print("Area of triangle is ",area) ====================================== 4. Write a program to calculate area of circle. r=float(input...

Full course of c++ programming language Click here > C++ programming language 1 ] print the message in pl/sql block.  set serveroutput on; begin  dbms_output.put_line('Welcome to pl/sql world'); end; / ========================================== 2 ] create a pl/sql block for print 1 to 10 numbers.  set serveroutput on; declare  i number:=1; begin  while(i<=10)   loop    dbms_output.put_line(i);    i:=i+1;   end loop; end; / ========================================== 3 ] create a pl/sql block for print any message for number of time?  set serveroutput on; declare  i number:=1; begin  while(i<=5)loop   dbms_output.put_line('Hello world');   i:=i+1;  end loop; end; / ========================================== 4 ] create a pl/sql block for print the message for particular times?  set serveroutput on; declare  msg varchar(25):=&message;  n number:=&n;  i number:=1; begin ...