Answer Posted / shilpa.oracle

Yes, we can relate tables of different schemas provided we
should have privileges on that table

create table test_emp
(empno number(5),deptno number(5),constraint dept_ref
foreign key (deptno) references schema.dept(deptno))

What do you think about pl/sql?

950

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

993

---

what is the difference between primary key and unique key? : Sql dba

972

---

What are sql*plus environment variables?

1032

---

How to pronounce postgresql?

1009

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1788

---

Explain character-manipulation functions?

1070

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1021

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1066

---

What is indexing oracle sql?

1026

---

Can 2 queries be executed simultaneously in a distributed database system?

1084

---

What is the difference between alter trigger and drop trigger statements?

1044

---

How does a covering index work?

907

---

What does data normalization mean?

900

---

Can we join same table in sql?

964

---