Category Archives: All Posts
In this article you will learn about how to add and delete user in Linux operation system, how to get memory information and partition information. First login as root user and practice following commands. It is also recommended to create another user and practice on the dummy user. login as: root firstname.lastname@example.org's password: Last login:
Just follow the below mentioned steps to send an e-mail from Oracle 10g database using PL/SQL. Step:1 First install SMTP Service in Server as per steps given below. Go to Control Panel-> Add or Remove Programs-> Click on Add/Remove Windows Components Select Internet Information Service (IIS) option and click on Details button to check whether
You can use these best and easy tips to Transpose rows into columns. You can also Transpose columns into rows in Oracle.
The purpose of SQL join is to combine rows from multiple tables. SQL join is performed by the where clause which combines two or more tables in an SQL statement. There are four types of joins which described below: INNER JOIN or sometimes called SIMPLE JOIN LEFT OUTER JOIN or sometimes called LEFT JOIN RIGHT
First create a PLANNING table in oracle using following script. CREATE TABLE PLANNING (CITY VARCHAR2(25), TYPEOFCITY VARCHAR2(20), CONSUMERS NUMBER(20), SURVEYEDCONSUMERS NUMBER(20)); Now insert some dummy records in the table. insert into PLANNING values ('AJMER','URBAN',85589,45836); insert into PLANNING values ('AJMER','RURAL',13853,8328); insert into PLANNING values ('BHILWARA','URBAN',54149,27327); insert into PLANNING values ('BHILWARA','RURAL',8384,4331); insert into PLANNING values ('NAGOR','URBAN',49752,43919); insert