Answer / Santosh Singh Dhakariyal

RAW in Oracle is a data type used to store binary data of fixed length or variable length. It is useful when dealing with images, videos, or other types of binary data.

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

1 Answers   ESS,

---

Explain the use of rows option in imp command.

1 Answers  

---

What is raw datatype?

1 Answers  

---

What are the types of partitions in oracle?

1 Answers  

---

Why packages are used in oracle?

1 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

hai, when to use char and varchar2....?

2 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,

---

What is the meaning of recursive hints in oracle?

1 Answers  

---

How to call a stored function with parameters?

1 Answers  

---

What is a static data dictionary in oracle?

1 Answers  

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---