Answer / swetha

1) sql*loader is used only to load data into database
tables from external files.
It's all about data loading.


2) Import is used to read and write the operating system
files in and out of database.
it's completely a different aspect.

We can deal with structures as well as data here.
We can import entire database or a particular user/schema
or required table spaces with structures or even with data
according to the requirement.

where the dff data will be stored

0 Answers   Infosys,

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

0 Answers   Wipro,

---

When the procedures or packagess become invalidate

3 Answers   TCS,

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

HOW TO SPOT AHIERARCHY?

0 Answers  

---

How can you enable a trace for a session?

2 Answers  

---