Answer / surya

Do we have constraining table in oracle :(

Answer / atul

constraining table is used in trigger
this is table where used foreign key on that table(i.e)
one table depand upon another table

How do I count records in sql?

0 Answers  

---

What is case function?

0 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

What are sql constraints?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

How do rank () and dense_rank () differ?

0 Answers  

---

What is snowflake sql?

0 Answers  

---

What is trigger with example?

0 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---