Databases

triggerthat · 9 Nov 2006 at 15:56

Hi guys,

We use Oracle SQL Developer at University to queries databases etc.

What application is required exactly to make databases?

Am all new to Oracle so sorry in advance.

Baz · 9 Nov 2006 at 17:07

Do you mean what applications can access a database or what creates a database?

Oracle/DB2/SQL server are the actual database engines/servers if you like, and pretty much anything can access them, whether it be web pages, specific programs, visual studio created programs, in all sorts of langauages, Delphi, C#, ASP, ASP.net etc etc.

Welshy · 9 Nov 2006 at 19:43

triggerthat said:
Hi guys,

We use Oracle SQL Developer at University to queries databases etc.

What application is required exactly to make databases?

Am all new to Oracle so sorry in advance.

It'd probably be best to ask your lecturer about this, as there's so many answers to your question

triggerthat · 10 Nov 2006 at 20:34

Hi,

Unfortunately my lecturer is away.

Yes, am basically looking for an application which creates tables etc.

Energize · 10 Nov 2006 at 20:40

Microsoft access can be used to create databases.

triggerthat · 10 Nov 2006 at 21:15

Energize said:
Microsoft access can be used to create databases.

Sorry I mean Orcale databases.

Energize · 10 Nov 2006 at 21:45

At school we use "dezign" to model and create the oracle databases we use.

oneilldo · 11 Nov 2006 at 11:10

if you use SQL developer to querie tables then acn't you just use that to create new ones??

i.e.
use DBName
Create Table TEST (
id INT NOT NULL,
.....
)

TrUz · 11 Nov 2006 at 12:12

If you are using Oracle then the weapon of choice is usually TOAD.

TrUz

Mel_P · 11 Nov 2006 at 13:28

There should be a database manager - you then type your SQL queries in this - or in some text editor - can be tedious.