What is information schema in database?

0 Answers  

---

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?

3 Answers  

---

Can a DIALOG WINDOW have scroll bar attached to it ?

1 Answers  

---

what is the use of SYSTEM.EFFECTIVE.DATE varaible ?

1 Answers  

---

What's the difference between clustered and non-clustered indexes?

0 Answers  

---

How to use multiple database server in back end ?

0 Answers   MCN Solutions,

---

Define stored procedures.

0 Answers  

---

Explain the difference between dbms and rdbms?

0 Answers  

---

What is the use of PARFILE option in EXP command ?

1 Answers  

---

What is Two-Phase Commit ?

3 Answers  

---

Enlist some commands of dml?

0 Answers  

---

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

0 Answers  

---