如何通过 sql Developer 连接到 sql 数据库？
所以，我已经下载了一个 .sql 文件，并且想知道如何通过我也下载的 sql Developer 连接到它。我需要使用主机名和端口等创建连接吗？我可以手动/直接连接到文件吗？
另外，有人可以推荐一个好的数据库来供初学者练习/学习吗？我应该下载 oracle 11g 并使用它吗？
谢谢。
So, I have a .sql file that I have downloaded and was wondering how I connect to it via sql developer which I have also downloaded. Do I need to create a connection with hostname and port etc? can I just connect to a file manually/directly or something?
Also, can anyone recommend a good database to practice/learn on for a beginner? Should I just download oracle 11g and play around with that?
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您无法连接到 .sql 文件，因为它不是数据库。 Oracle 本身作为服务器运行。如果您还没有访问服务器的权限，那么您将需要获取一台服务器。
幸运的是，Oracle 发布了一个可以免费使用的服务器，它将帮助您熟悉事物。看看 Oracle Lite
我想你可能会发现设置开发环境是一个相当大的挑战，但如果您有耐心并有决心，您就可以实现这一目标。一旦您拥有了可以使用的服务器，您就可以开始尝试 Sql，这是您用来查询数据库的语言。
祝你好运。
You cannot connect to a .sql file because it is not a database. Oracle runs as a server in its own right. If you do not already have access to a server then you will need to get one.
Fortunately, Oracle publishes a server you can use free of charge that will help get you into the swing of things. Have a look at Oracle Lite
I think you might find it quite a challenge getting yourself set up with a development environment but if you are patient and determined you can get there. Once you have a server to play with you can start to experiment with Sql, which is the language you use to interrogate the database.
Best of luck.
您需要 tns 侦听器正在侦听的 SID 以及 IP 地址和端口号（通常为 1521）。
连接后，您将能够针对该数据库运行 sql 文件。
是的，在盲目地进入数据库访问世界（例如 .sql 文件）之前，最好先充分了解 Oracle
You'll need the SID as well as the ip address and port number (typically 1521) that tns listener is listening on.
Once you've connected, you'll be able to run your sql file against that database.
And yes, it would be a good idea to have a good understanding of Oracle before wandering off blindly into the world of database access (.sql files, for example)