can you please link the videos that go more in depth about the connections? i’m not even sure what a connection is, like am i supposed to have a database made already and then connect it to this app?
Sure! The video is here: ruclips.net/video/Ttzc2WCKcNo/видео.html A connection is the name for a group of settings that allow you to access a database. The Oracle database "server" needs to be installed for the connection to work. You can enter the settings for the connection, but without the database for SQL Developer to connect to, the connection won't work. You don't need any tables or anything set up first - you just need the Oracle database server. You could use Oracle Express, or Oracle Free Cloud, or an Oracle database you have at work. Hope that helps.
@@DatabaseStar thanks so much, i’m a student so i was just playing around with this app on my own and it’s not for work or anything. your response really helped though, a lot of other videos never mention that i’d need to have the oracle server installed for this to work.
I am using Oracle Linux on a Dell 3410 laptop with Oracle 19c installed the menu fonts for the SQL developer on the left panel and menu in general are too small, is there a way to change those? I have changed the editor's font, which works, the other thing I can do is to change my laptop screen resolution size or its zooming, which will take away from my working space. Thank you for these great tips.
You skipped the password part at 2:02 What is the password for it ? and i am getting this error even after giving all data from your video .... error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
The password depends on your database and how it is installed. If you installed it on your computer, you specified it when you installed it. If it’s at work or school then they would know it.
I have a table but there are some columns that I don't plan on using. Normally when I'd use a table I'd just select the entire table but what do I do in this case? for example, I don't want to use the first and last columns and I just want to select everything in the middle, how do I do that?
You can right click on the table and generate a Select query, paste the query into the SQL Editor and remove the columns you don't need. That might be the fastest way.
I have a problem with the password, I downloaded the program and I encountered a problem with the username and password, and I did not put these things previously, I just downloaded the program
Ah, the password is related to the database you're accessing. This could be Oracle Express or the Oracle Standard Edition for example. You can reset the password if you don't know it.
Which page are you referring to? The closest I have to common questions is this one on common connection issues: www.databasestar.com/oracle-connection-issues/
@@DatabaseStar yeah thanks for the reply…so we shd connect to the dB server from the cmd line, for that we need sqlplus, do you have any idea on that???
i have this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=31fu4cV+QFKO5ZUDfzHwVQ==) what can i do? :(
Do you want to save time while using SQL Developer? Get my Timesaver Guide to Oracle SQL Developer here: www.databasestar.com/timesaver-sqldeveloper/?
You just summarized a 1.5 hour lecture to less that 10 minutes. Thanks!
Thanks! Glad I saved you some time!
This is the thing I needed! Thank you!
No problem, glad it was helpful!
can you please link the videos that go more in depth about the connections? i’m not even sure what a connection is, like am i supposed to have a database made already and then connect it to this app?
Sure! The video is here: ruclips.net/video/Ttzc2WCKcNo/видео.html
A connection is the name for a group of settings that allow you to access a database. The Oracle database "server" needs to be installed for the connection to work. You can enter the settings for the connection, but without the database for SQL Developer to connect to, the connection won't work. You don't need any tables or anything set up first - you just need the Oracle database server. You could use Oracle Express, or Oracle Free Cloud, or an Oracle database you have at work. Hope that helps.
@@DatabaseStar thanks so much, i’m a student so i was just playing around with this app on my own and it’s not for work or anything. your response really helped though, a lot of other videos never mention that i’d need to have the oracle server installed for this to work.
Where is the link that you have linked in the description? (you said that at 2:52)
Thanks for pointing it out! The link is here: www.databasestar.com/oracle-connection-issues/
I'll add it to the description too.
I am using Oracle Linux on a Dell 3410 laptop with Oracle 19c installed the menu fonts for the SQL developer on the left panel and menu in general are too small, is there a way to change those? I have changed the editor's font, which works, the other thing I can do is to change my laptop screen resolution size or its zooming, which will take away from my working space.
Thank you for these great tips.
I’m not sure how to do it on Linux unfortunately other than what you have done.
You skipped the password part at 2:02 What is the password for it ?
and i am getting this error even after giving all data from your video ....
error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
The password depends on your database and how it is installed. If you installed it on your computer, you specified it when you installed it. If it’s at work or school then they would know it.
do you have tutorial how to installation SQL Developer on Mac? i urgently needed
I do have one coming out soon, but it’s pretty straightforward. Download the installer and drag the file to your Applications folder.
I have a table but there are some columns that I don't plan on using. Normally when I'd use a table I'd just select the entire table but what do I do in this case? for example, I don't want to use the first and last columns and I just want to select everything in the middle, how do I do that?
You can right click on the table and generate a Select query, paste the query into the SQL Editor and remove the columns you don't need. That might be the fastest way.
Thank you! It is very useful
Glad it was helpful!
I have a problem with the password, I downloaded the program and I encountered a problem with the username and password, and I did not put these things previously, I just downloaded the program
Ah, the password is related to the database you're accessing. This could be Oracle Express or the Oracle Standard Edition for example. You can reset the password if you don't know it.
Link to a page to resolve common database questions?
Which page are you referring to? The closest I have to common questions is this one on common connection issues: www.databasestar.com/oracle-connection-issues/
Amazing information
Thanks!
I want to run DBSAT tool, how can I do that using sql developer?
I’m not sure how to run it using sql developer. What does the documentation say? From what I can tell it’s a command line tool.
@@DatabaseStar yeah thanks for the reply…so we shd connect to the dB server from the cmd line, for that we need sqlplus, do you have any idea on that???
i have this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=31fu4cV+QFKO5ZUDfzHwVQ==)
what can i do? :(
I think either the docker container is not running or the SID is incorrect. Other commenters have had similar issues.
where is the page to resolve the problems
Which page? Which problems are you referring to?
what is the password?? @ 2:02
It depends on how your database is set up, and I explained more in the other comment.
Why Oracle is so ugly ? All looks like since 1990 not changed