Answer / chaudhry

Schema objects are the logical structures that directly
refer to the database's data. Schema objects include tables,
views,
sequences, synonyms, indexes, clusters, database triggers,
procedures, functions packages and database links.

Answer / nishi

Schema objects are logical data storage structures. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the database.

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

What is a cluster?

2 Answers  

---

Can a primary key contain more than one columns?

2 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

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,

---

Explain the importance of .pll extension in oracle?

0 Answers  

---

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

---

How are extents allocated to a segment?

0 Answers  

---

What is the oracle implicit cursor?

0 Answers  

---

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

1 Answers  

---

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---