To Perform various data manipulation commands, aggregate functions and sorting
concept on all created tables in previous tutorial.
Queries
List total deposit from deposit.
select sum(amount)from deposit_gtu;
List total loan from karolbagh branch
select sum(amount) from deposit_gtu where bname='Andheri';
Give...
Sunday, 11 June 2017
DBMS Tutorial-2
create table Job ( job_id varchar2 (15), job_title varchar2 (30) , min_sal number (7,2) , max_sal number (7,2));
insert into Job values('&job_id','&job_title','&min_sal','&max_sal');
create table Employee (emp_no number (3), emp_name varchar2 (30), emp_sal number (8,2), emp_comm...
Saturday, 10 June 2017
DBMS Tutorial-1
CREATE TABLE DEPOSIT (ACTNO VARCHAR2(5),CNAME VARCHAR2(18),BNAME VARCHAR2(18),AMOUNT NUMBER(8,2),ADATE DATE);
INSERT INTO DEPOSIT VALUES('&ACTNO','&CNAME','&BNAME','&AMOUNT','&ADATE');
CREATE TABLE BRANCH(BNAME VARCHAR2(18),CITY VARCHAR2(18));
INSERT INTO BRANCH VALUES('&BNAME','&CITY');
CREATE...
Friday, 9 June 2017
Networking Program
Network Program List
Client & Server Using TCP Connection
Client & Server Using UDP Connection...
Sunday, 4 June 2017
JAVA-Concept Wise Program
Program List
Class Program
Stack Program
Recursion
Method Overloading
Constructor & Constructor Overloading
This Keyword
Static variable, Static Method & Static Block
Inner & Outer Class
Finalize Method...
JAVA Tutorial-7
Write a Main method that takes the name of a text file as a command line argument and
prints every line in lower case.
Write a main() method that counts the number of words in a text file whose name...
Saturday, 3 June 2017
JAVA Tutorial-6
Program 1
Program 2
Program 3
Program 4
1. Write a program to insert values into an array.
The user will enter a sequence of index and value to be stored at that index on the command line....
