All posts by DreamMaker

10Feb/16

SELECT, WHERE, DISTINCT and ORDER BY

February 10, 2016RDBMSdistinct, orderby, select_statement, whereDreamMaker

SELECT Select command is used to fetch records from the database table and display on the screen. Syntax: SELECT*FROM <table_name>; Example: SELECT * FROM student; It will display all the records fromRead More…

10Feb/16

INSERT INTO

February 10, 2016RDBMSinsert_intoDreamMaker

Insert command is used to insert records into the database table. Syntax: INSERT INTO <table_name> VALUES(val1,val2, val3,…,valN); Example: INSERT INTO student VALUES(1,’ABC’,’Ahmedabad’); It can be helpful for inserting record for all theRead More…

10Feb/16

CREATE TABLE

February 10, 2016RDBMScreate_tableDreamMaker

CREATE TABLE command is used to create a database table. Syntax: CREATE TABLE <table_name>( <column1><datatype> (size), <column2><datatype> (size),… <column N><datatype> (size)); Example: CREATE TABLE student( std_no number(3), std_namevarchar2(10), Cityvarchar2(10)); Where, table_name isRead More…

10Feb/16

Client-Server Architecture

February 10, 2016RDBMSclient-server-architectureDreamMaker

A client server architecture is an arrangement of computer in which different computer are connected with a single pc. It is a one type of network. A central PC to whom otherRead More…

09Feb/16

Command-Line Arguments

February 9, 2016Javacommand-line-argumentsDreamMaker

Sometimes we need to pass arguments with main () function We can do so by using command-line arguments Command-line argument is the information that is passed with program name while running theRead More…

09Feb/16

Conditional Statements

February 9, 2016Javaconditional-statements, if-else, if-else-ladder, if-statementDreamMaker

Java provides IF conditional statements for executing statements based on some condition It can be used to take decision and follow certain execution path conditionally It has the following form:       ifRead More…

09Feb/16

Arrays

February 9, 2016Javaarray, types-of-array, what-is-arrayDreamMaker

An array is a collection of similar data types that share a common name. Arrays of any type can be created and may have one or more dimensions. Array elements can beRead More…

09Feb/16

Operators

February 9, 2016Javajava-operators, operatorsDreamMaker

An operator is a symbol that tells the computer to perform certain mathematical or logical calculations. Operators are used in programs to manipulate data and variables. Java provides the following operators: ArithmeticRead More…

09Feb/16

Data Types

February 9, 2016Javadata-types, java-data-typesDreamMaker

There are two categories of data types Primitive types Non primitive types Java provides eight primitive types of data: Byte Short Int Long Char Float Double Boolean The primitive types are alsoRead More…

23Jan/16

First Hello Word Program

January 23, 2016Javafirst-java-program, helloWordDreamMaker

Example Program: class HelloWord { public static void main(String args[]) { System.out.println(“Welcome to Java”); } } Explanation: class HelloWord: Class is a keyword and HelloWord is the name of the class. public:Read More…