Answer Posted / ramya

The Structure of the table is known as tablespace,
create tablespace
users
datafile
‘/ora01/oracle/oradata/booktst_users_01.dbf’
size
50m;
using alter query we can manage the tablesapace

What is the database name in oracle?

1078

---

Give the advantages and disadvantages of clusters.

1096

---

How to create an initialization parameter file?

1106

---

how may join possible between (requisition with purchase order)

2330

---

What is Redo Log Buffer in Oracle?

1282

---

How to use null as conditions in oracle?

1127

---

Explain index?

1314

---

What is an oracle user account?

1043

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3385

---

What is background process in Oracle?

1140

---

How to create a table index?

1230

---

How do I know if oracle is installed on windows?

987

---

Point out the difference between user tables and data dictionary?

1037

---

What exactly do quotation marks around the table name do?

1027

---

How do we display rows from the table without duplicates?

1019

---