what is meant by tuning and tk proof?

2 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  

---

What is meaning of <> in sql?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

what are set operators in sql? : Sql dba

0 Answers  

---

how to convert dates to character strings? : Sql dba

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

What is bitemporal narrowing?

0 Answers  

---

Can we insert in sql function?

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,

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---