Can we perform dml on view?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

How do you declare a user-defined exception?

0 Answers  

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

what is commit? : Sql dba

0 Answers  

---

Does truncate remove indexes?

0 Answers  

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

What is a sql instance vs database?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---