what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

What is the purpose of design view?

0 Answers  

---

Why use stored procedures?

0 Answers  

---

Difference between table function and pipelined function?

0 Answers  

---

What is the difference between joins?

0 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

Which one is better subquery or joins?

0 Answers  

---

What are the different types of joins and explain them briefly.

3 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

What are the benefits of pl/sql packages?

0 Answers  

---