Answer Posted / amit

Suppose your 2 databases are name as PROD1 and PROD2
1) How can create a table in particular database?
=> First you have to connect to the database where you want
to create table with given login and password.
and then if you have create permission than you can use
following sql
CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

2) select * from tab; will show you how many tables,view or
synonyms are there in your schema.

what is meant by urlencode and urldocode? : Sql dba

603

---

How do I make sql search faster?

554

---

Differentiate pl/sql and sql?

562

---

Does a user_objects view have an entry for a trigger?

570

---

What are the basic techniques of indexing?

575

---

---

What is view? Can we update view

867

---

what are the t string functions available in tsql? : Transact sql

542

---

How is data stored on a disk?

538

---

what is 'mysqlcheck'? : Sql dba

573

---

what is the functionality of the function htmlentities? : Sql dba

521

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

534

---

difference between anonymous blocks and sub-programs.

622

---

What is a behavioral trigger?

515

---

what is a record in a database ? : Sql dba

566

---

what is the difference between truncate and delete statement? : Transact sql

548

---