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;

What is Console Application? & The purpose Of Console Application? with description.

1 Answers  

---

Write a Pseudo Code to fins the LCM of two given numbers

5 Answers   Goldman Sachs,

---

Find out the roles which gives access to all tables in SAP? Thanks in advance.

0 Answers  

---

What are the compilers of JAVA and .NET Programming languages?

1 Answers   HCL, Microsoft,

---

major characteristics of software system

0 Answers  

---

---

1. Consider the following code in our example assembly language: ; an example bit of assembly code ROOT: W FATHER FATHER: W SON1 W SON2 SON1: W NIL W NIL ; ---------------------- SON2: W GRANDSON W NIL GRANDSON: W NIL W NIL NIL = 0 Assemble this code carefully following the two pass model, and show the symbol table at the point marked by the dashed line during each pass.

0 Answers   TCS,

---

which property is used to display the advertisements with adrotator control

0 Answers   Sonata,

---

.net 2005 supports how many languages?

4 Answers  

---

2.Different data types in C? and its value and range?

2 Answers  

---

without selecting individually each field in Action Class from jsp,what is the best process to select as many as field at a time automatically from jsp page by using value object class.

0 Answers  

---

What is meant by spooling

2 Answers   Qiscet,

---

Code for display the images from drive using vb 6.0?

2 Answers   IBM,

---