atish chachan

Greenhorn
+ Follow
since Jul 20, 2006
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by atish chachan

hi,

To export the contents of a table you can use the SPOOL command.

> spool d:\abc.txt
> select * from table_name;
> spool off

This will export the contents of the table to a text file named abc.txt in the D drive.

cheers!
17 years ago
Hi

I am planning to take the OCA 1Z0-031 exam.
I have cleared 1Z0-007 last week.

I wanted to know about 1Z0-031 that what is the passing score and how many questions are there in the exam...?

And where can i get the sample papers for this exam?

Thanks..
17 years ago
Thanks Shital..

Actually i have the tables already created in the database.

But the Primary Keys have not been defined for the tables.

Is there any way through which i can find out which columns are the primary keys for a table?
17 years ago
hi,
I am new to Oracle.Just started using it.Could anyone help me with this problem. I have many tables in my database. I want to identify the primary keys for a particular table. When i give DESC tablename, it does not show the constraint Primary Key for the table. How do i identify the primary keys for the table.
17 years ago