Answer Posted / thirupathi.l

using native dynamic sql we can directly use DML and DDL
statements.
ex:native dynamic sql
declare
a varchar2(1000);
begin
a:='create table <tname>(elements)
execute immediate a;
end;

where as in dbms_sql package also we can use dml and DDL
but here declare cursor
coding is so lenthy
thats why currently using native dynamic sql

what is port in oracle? how is it related to database application.

1949

---

What are a collation and state the different types of collation sensitivity?

1170

---

Explain table?

1118

---

What do you mean by merge in oracle?

996

---

What's dateware house and what's clustor with practicle example

2175

---

What is the difference between postgresql and oracle?

1049

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2276

---

What is the recommended interval at which to run statspack snapshots, and why?

2920

---

How to insert a new row into a table in oracle?

1165

---

How to use in conditions in oracle?

1058

---

Can you have more than one content canvas view attached with a window ?

2333

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2265

---

Give the different types of rollback segments.

1031

---

Explain parameter file in oracle.

1030

---

Use of an integrity constraint is better to validate data. Explain

1041

---