how can ur insert the emp table

Question Posted / ammuk221

3 Answers
6163 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can ur insert the emp table..

Answer / kumar

Alredy We are having the emp table in our database at the
time only we can insert the data otherwise not possible.

We can insert the data into emp table into 2 ways by using insert command.Two syntax of insert command given below

1.insert into tablename values(<values list>)
2.insert into tablename(<column list>) values(<spcified column values >)

Is This Answer Correct ?

36 Yes

0 No

how can ur insert the emp table..

Answer / ammuk221

insert into emp values(serialno,'emp
name','hiredate',emppost,salary,deptno,commission);

Is This Answer Correct ?

12 Yes

7 No

how can ur insert the emp table..

Answer / madhav

BY USING 'ON THE FLY TABLES'
CREAT TABLE EMPLOYEE AS SELECT * FROM EMP WHERE 1=2;
(FOR TABLE STRUCTURE)
-----TO INSERT THE EMP TABLE VALUES-------
INSERT INTO EMPLOYEE(SELECT * FROM EMP);
(INSERT THE EMP TABLE DATA)
SELECT * FROM EMPLOYEE;

-----------ALL THE BEST-------------

Is This Answer Correct ?

0 Yes

0 No

Post New Answer