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....
JAVA Tutorial-5
Program 1
Program 2
Program 3
Program 4
Program 5
Program 6
1. The abstract Vegetable class has three subclasses named Potato, Brinjal and Tomato. Write
an application that demonstrates how...
Friday, 2 June 2017
JAVA Tutorial-4
Program 1
Program 2
Program 3
Program 4
Program 5
1. create a class called student having data member like name,enr,branch,city,spi
define construct which can ini data member
define method...
JAVA Tutorial-3
Create an array of String variables and initialize the array with the names of the months from January to December.
Create an array containing 12 random decimal values between 0.0 and 100.0. Display...
Thursday, 1 June 2017
JAVA Tutorial-2
Write a program to display a random choice from a set of six choices for breakfast (you could use any set;
for example, scrambled eggs, waffles, fruit, cereal, toast, or yogurt).
When testing whether...
JAVA Tutorial-1
Demonstrate HelloWorld Application with Single and Multiple Main in a java program.
Write a console program to define and initialize a variable of type byte to 1,
and then successively multiply it...
