Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is mdf ldf and ndf?

0 Answers  

---

what is index? : Sql dba

0 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

How do I copy a table in sql?

0 Answers  

---

---

Explain what is a database?

0 Answers  

---

Explain the savepoint statement.

0 Answers  

---

What are the basic techniques of indexing?

0 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---

Explain normalization and what are the advantages of it?

0 Answers  

---

What is the use of partition by in sql?

0 Answers  

---

Can we use delete in merge statement?

0 Answers  

---