CODEWITHSUNDEEP
sql-serverdatabaseoracle-database
W.M
W.M

Reputation: 11

Oracle SQL Developer and Microsoft SQL Server

I was following along with a Youtube tutorial on a Visual Studio and SQL connection. But in the Youtube video, it uses Microsoft SQL Server which is different from the one I'm using. There is a step that he did, but I could not find it in my Oracle SQL Developer.

He signed in with username and password and from his connection he found in the "Connection" bar on the left of the screen, a "database" folder then he right clicked it and chose "new database". In my Oracle I don't have this "database" folder, I have "database links" which seems different when I click it. if you know how to find this same folder please help.

Upvotes: 0

Views: 237

Answers (1)

William Robertson
William Robertson

Reputation: 15991

The term 'database' means very different things in Oracle and SQL Server. In SQL Server it means something like a user account. In Oracle, a database is the whole installation, with data files, the lot. It's not something you do lightly with a click of a button for a SQL tutorial.

To run the tutorial in Oracle, you probably need to create a user, not a database.

Is Schema in Oracle is equivalent to Database in Microsoft SQL Server?

Upvotes: 3

Related Questions