Answer Posted / smnad

Every design that we made in the data base is called as
schema .like table , namefeild , columns and all the feild
that will be generated by the user is called as schema.

Whats the benefit of dbms_stats over analyze?

2064

---

Is there an oracle sql query that aggregates multiple rows into one row?

1021

---

How to turn on or off recycle bin for the session?

1173

---

How to filter out duplications in the returning rows using oracle?

1064

---

How can I create database in oracle?

1066

---

What is the data type of dual table?

1062

---

Explain oracle 12c new features for developers?

1121

---

What is oracle in java?

1013

---

How do I recompile a procedure in oracle?

1015

---

How to concatenate two text values in oracle?

1152

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2341

---

How to see the table columns used in an index?

1070

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1436

---

What is the quickest way to fetch the data from a table?

1100

---

What privilege is needed for a user to query tables in another schema?

1029

---