What are tables and fields in the database?

0 Answers  

---

What does select top 1 do in sql?

0 Answers  

---

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

---

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

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  

---

Which data type is a composite type?

0 Answers  

---

How to write a query to show the details of a student from students table whose

0 Answers  

---

What is the need of merge statement?

0 Answers  

---

what are date and time data types in mysql? : Sql dba

0 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---