My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
RDBMS programs
Posted Date: 11 Mar 2008 Resource Type: Articles/Knowledge Sharing Category: General
|
Posted By: P.Muthukumar. Member Level: Silver
Rating:  Points: 2
|
|
|
SQL> create table newemp1(empno number(7),empname varchar(15),deptname varchar(10),salary
2 float,grade varchar(5));
Table created.
SQL> insert into newemp1 values(&empno,'&empname','&deptname',&salary,'&grade');
Enter value for empno: -101
Enter value for empname: raj
Enter value for deptname: BCA
Enter value for salary: 10000.50
Enter value for grade: A
old 1: insert into newemp1 values(&empno,'&empname','&deptname',&salary,'&grade')
new 1: insert into newemp1 values(101,' raj','BCA',10000.50,'A')
1 row created.
SQL> /
Enter value for empno: 102
Enter value for empname: ARUN
Enter value for deptname: Bbm
Enter value for salary: 12000.70
Enter value for grade: B
old 1: insert into newemp1 values(&empno,'&empname','&deptname',&salary,'&grade')
new 1: insert into newemp1 values(102,' ARUN','Bbm',12000.70,'B')
1 row created.
SQL> /
Enter value for empno: 103
Enter value for empname: Kumar
Enter value for deptname: mca
Enter value for salary: 9000.43
Enter value for grade: C
old 1: insert into newemp1 values(&empno,'&empname','&deptname',&salary,'&grade')
new 1: insert into newemp1 values(103,'Kumar ','mca',9000.43,'C')
1 row created.
SQL> /
Enter value for empno: 104
Enter value for empname: Madhan
Enter value for deptname: MBA
Enter value for salary: 25500.35
Enter value for grade: b
old 1: insert into newemp1 values(&empno,'&empname','&deptname',&salary,'&grade')
new 1: insert into newemp1 values(104,'Madhan','MBA',25500.35,'b')
1 row created.
SQL> select lower(empname) from newemp1;
LOWER(EMPNAME)
---------------
raj
arun
kumar
madhan
SQL> select upper(empname) from newemp1;
UPPER(EMPNAME)
---------------
RAJ
ARUN
KUMAR
MADHAN
SQL> select ltrim(empname) from newemp1;
LTRIM(EMPNAME)
---------------
raj
ARUN
Kumar
Madhan
SQL> select rtrim(empname) from newemp1;
RTRIM(EMPNAME)
---------------
raj
ARUN
Kumar
Madhan
SQL> select substr(empname,3,4) from newemp1;
SUBS
----
aj
RUN
mar
dhan
SQL> select abs(empno) from newemp1;
ABS(EMPNO)
----------
101
102
103
104
SQL> select empno from newemp1;
EMPNO
----------
-101
102
103
104
SQL> select ceil(salary) from newemp1;
CEIL(SALARY)
------------
10001
12001
9001
25501
SQL> select floor(salary) from newemp1;
FLOOR(SALARY)
-------------
10000
12000
9000
25500
SQL> select sum(salary) from newemp1;
SUM(SALARY)
-----------
56501.98
SQL> select avg(salary) from newemp1;
AVG(SALARY)
-----------
14125.495
SQL> select min(salary) from newemp1;
MIN(SALARY)
-----------
9000.43
SQL> select max(salary) from newemp1;
MAX(SALARY)
-----------
25500.35
SQL> select count(*) from newemp1;
COUNT(*)
----------
4
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
Watch TV Channels
Watch Asianet TV onlineKairali TV in InternetSurya TV onlineAmritha TV Channel
|