Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to learn the basics of sql developer using oracle database xe

TracyW19Feb 25 2020 — edited Feb 28 2020

hello,

i am new to oracle and can't find any straight forward documentation for creating what i think are basics things:

1. a test database if you will, that i can play around with to create queries and views.

2. a user account that has full rights to the test database, including testing it.

3. a connection for the user account that i create to the test database

4. import tables from sql server or mysql, which ever is easier

prior to this message, i tried on my own to create a user account and connection, but it failed. i posted a message, but honestly don't understand the response, so i went looking for documentation to get a better understanding.

i have gone through the users guide for sql developer on this page, but it does not have what i am looking for.

https://docs.oracle.com/en/database/oracle/sql-developer/19.4/rptug/lof.html

is there any other documentation that would cover this type of 'getting started' information?

i have looked for books, but they seem to stop at version 12c.

i have used other sql databases (sql server, mysql etc) and did not have such difficulties in finding documentation or creating a test database and using account, so i don't know what i'm missing when it comes to oracle.

any help would be greatly appreciated.

thank you 

Comments
Post Details
Added on Feb 25 2020
5 comments
1,203 views