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))

Can we create table inside stored procedure?

961

---

What do you mean by stored procedures? How do we use it?

996

---

What is set serveroutput on in pl sql?

1302

---

Is merge a dml statement?

984

---

What is difference between db2 and sql?

1007

---

what happens if you no create privilege in a database? : Sql dba

1006

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1113

---

What is the difference between left and left outer join?

950

---

How do I restart sql?

979

---

What is database sql?

1058

---

what is 'mysqldump'? : Sql dba

1113

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1022

---

What can you do with pl sql?

1097

---

What are pl/sql cursor exceptions?

1110

---

Is sqlite thread safe?

1057

---