Answer Posted / amrit paul-genpact

Normally we would write codes using Native Dynamic SQL(NDS).
This is because NDS heps writing clear, understandable code
where trouble shooting is apparently very easy.
However there might be situations when the input to a
EXECUTE IMMEDIATE code might use a SQL Text which is
greater than 32KB, thus over-ruling the max specified size
of PL/SQL VARCHAR2 limits. This is a clear situation where
we could use the DBMS_SQL package.

How to define a record variable to store a table row?

1021

---

How to commit the current transaction in oracle?

1058

---

What is tns entry?

1073

---

How to select all columns of all rows from a table in oracle?

1013

---

How to bring a tablespace offline?

1010

---

Explain the use of control file?

1075

---

How to use select statement to count the number of rows in oracle?

1003

---

Does facebook use oracle?

993

---

Is it possible to split the print reviewer into more than one region ?

2235

---

What the is the diff between local index and global index. give some example.

1595

---

What is integrity and what is constraint??Explain with example

2229

---

What are ddl statements in oracle?

1027

---

Can we convert a date to char in oracle and if so, what would be the syntax?

974

---

How to create id with auto_increment on oracle?

950

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4125

---