what is table? : Sql dba

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

What is the difference between left join and right join?

0 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---

What is having clause in sql?

0 Answers  

---

How do I send sql query results to excel?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

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

0 Answers  

---

Can we use update in sql function?

0 Answers  

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---