What is an oracle txt editor?

Asked By Kimberly Walker 60 points N/A Posted on - 10/20/2012

Hello experts,

What is an oracle txt editor?

In the Oracle database there are some features that I don’t much get or understand like for instance, txt editor and import and exporting data. But I have to learn it all for I need to use it and connect with my Java programming language system.

I hope you can give me some answer.

Thank you.

 

• Status: Open
• Question Views: 812
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by sundar.msp

Go To Solution

Answered By Grace tomp 0 points N/A #175570

What is an oracle txt editor?

Oracle text editor is the text panel where you can write any kind of SQL code.

If you want to learn how you can go through the tutorials.

JDBC is the keyword to Google if you want to manipulate database from your program.

Using JDBC, you can connect database from your program.

About Grace tomp

Questions
2

Answers
18

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/20/2012
• Question Category: Oracle Database

Answered By Ailynhope ato -5 points N/A #175571

What is an oracle txt editor?

The text Editor tag is used to render multi-line editor control.

For more info regarding it you can check:

 

A comprehensive detail is present in the below link from where you can learn how to write the SQL Code in the Oracle panel

 

 

About Ailynhope ato

Questions
1

Answers
96

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 10/31/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By sundar.msp 0 points N/A #175572

What is an oracle txt editor?

1. Txt editor is used to write or edit SQL queries. If you are using sql*plus

You can define the _EDITOR variable as follows

For windows SQL> DEFINE _EDITOR=notepad
For Linux SQL> DEFINE _EDITOR=vi

Now if you type 'ed' in SQL prompt(SQL> ed). Notepad will open

2. Instance is used to access the database. It is a set of background processes and memory.
A Database is a set of files. You cannot directly interact with it. Through instance only you can work.
Every running Oracle database is associated with an Oracle instance (memory + process).
Memory for storing values & query results. Process for monitoring client requests & transferring data.

3. Importing & Exporting

Used to copy the tables & records from one system to another (or one database to another database).

 

About sundar.msp

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 11/20/2012
• Question Category: Oracle Database