Answer Posted / sudipta santra

ADDING THE CYCLE KEYWORD.

ALTER SEQUENCE SQ1 CYCLE;

Explain integrity constraint?

641

---

How do I limit the number of oracle database connections generated by weblogic server?

543

---

What is the scope of a local variable?

578

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

563

---

How translate command is different from replace?

542

---

---

What is varray?

582

---

Explain the difference between sql and oracle?

574

---

What are the varoius components of physical database structure of oracle database?

563

---

What is an oracle table?

550

---

How to declare a local variable?

590

---

How do you tell what your machine name is and what is its IP address?

1511

---

How to update values in a table in oracle?

569

---

Why use resource manager in Oracle?

659

---

How to export your connection information to a file?

590

---

How to build data dictionary view an new database?

524

---