Answer / nishi

SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database.

SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.

What is the difference between sharding and partitioning?

1 Answers  

---

Explain oracle instance.

1 Answers  

---

How to create a stored function in oracle?

1 Answers  

---

Explain about integrity constraint?

1 Answers  

---

12 RULES OF RDBMS

1 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

Whats the benefit of dbms_stats over analyze?

1 Answers  

---

What do you understand by a database object? Can you list a few of them?

1 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

When a form is invoked with call_form, Does oracle forms issues a save point ?

1 Answers   Oracle,

---

How to change system global area (sga) in oracle?

1 Answers  

---