How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

How long will it take to learn pl sql?

0 Answers  

---

What is secondary key?

0 Answers  

---

What does the argument [or replace] do?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

Can we use insert statement in function?

0 Answers  

---

What are different types of tables in sql?

0 Answers  

---

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What is varchar used for?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---