Answer / guest

I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?

To Modify the datatype of a column the column must be empty.

To add a column with NOT NULL constrain, the table must be
empty.

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

---

Can I create table without primary key?

0 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

---

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,

---

What is a composite primary key?

0 Answers  

---

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

What is a temp table?

0 Answers  

---

Why is pl sql needed?

0 Answers  

---

Which are the different character-manipulation functions in sql?

0 Answers  

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---