Answer / guest

create table emp(EMPID number(9),SAL number(10));
Result:creates a table named EMP.
a)alter table EMP add DEPTNO number(9);
Result:a new coloumn DEPTNO is added to the existing table EMP.
b)alter table EMP rename to EMP-RENAMED;
Result:renames the table name EMP to EMP-RENAMED.
c)update EMP-RENAMED
set SAL=SAL+10000
where EMPID>=xxxx;
Result:updates the salaries of Table emp depending upon the condition.
d)alter table EMP-RENAMED modify SAL varchar2(15);
Result:alters the SAL coloumn datatype to varchar2.

Answer / arvind agrawal

if want a column in table emp then perform above operation
sql>add deptno into emp;

how to get second highest salary from a employee table and how get a 5th highest salary from a employee table by using proc sql?

0 Answers   ABC,

---

I was try to insert 120000 records into the orcle table using the stroed proceeder. But it was stop the 9999. What can I do insert all the records.

2 Answers  

---

Given a arbitrary pointer to an element in a singly linked list?what is the time complexity for its deletion .

1 Answers   Hughes,

---

what is the system development cycle

0 Answers  

---

An image map is a collection of

1 Answers   Velocis,

---

List and explain any five built in functions for Lists data type in python

1 Answers   Peerless,

---

You are given some denominations of coins in an array (int denom[])and infinite supply of all of them. Given an amount (int amount), find the minimum number of coins required to get the exact amount. What is the method called?

0 Answers   Amazon,

---

what is the pl/sql block size in oracle 10g and 11g?

0 Answers  

---

whats the Need for Concurrency control

1 Answers  

---

What parameters are used to run a JCL JOB on a perticular DAY and TIME and DATE

1 Answers  

---

What is a PID? How is it useful when troubleshooting a system?

3 Answers  

---

what is best way to create a Thread class & why?

0 Answers  

---