Answer Posted / rk

Global temporary tables are distinct within SQL sessions.

The basic syntax is:

CREATE GLOBAL TEMPORARY TABLE table_name ( ...);

Is there any restriction on the use of union in embedded sql?

880

---

Does sql support programming?

769

---

What are the types of index in sql?

774

---

how to use like conditions? : Sql dba

782

---

what is meant by urlencode and urldocode? : Sql dba

770

---

---

What is the use of pl/sql table?

756

---

What does the acronym acid stand for in database management?

775

---

What is the difference between rename and alias?

971

---

what happens if null values are involved in expressions? : Sql dba

734

---

What is your daily office routine?

1986

---

Define commit?

745

---

How do I truncate a sql log file?

741

---

What is the maximum database size for sql express?

720

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3309

---

How do you optimize a stored procedure in sql?

679

---