Answer / Neha Sagar

A synonym in Oracle Database is an identifier that is another name for an existing valid identifier. Synonyms are used to mask the physical location of the object, simplify the application logic by referring to an object using a more descriptive or shorter name, and reduce naming inconsistencies across different schemas.

What is where clause in oracle?

1 Answers  

---

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 Answers  

---

Explain how are indexes update?

1 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

What is difference between SUBSTR and INSTR?

1 Answers  

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

1 Answers  

---

what are the default admin accounts in Oracle 10g ?

1 Answers   MCN Solutions,

---

What is logical backup in oracle?

1 Answers  

---

What is a relational database management system?

1 Answers  

---

How to create a new view in oracle?

1 Answers  

---

What is an anonymous block?

1 Answers  

---

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

1 Answers   Infosys,

---