Main reason is we are developing scripts in SQL developer, moving scripts to higher environments they are executing scripts in SQL*Plus. I am using remote database, so when i type Connect command or sqlplus commands in my command promt it will give an error like unknown command.because database not installed in my machine.
SQL DEVELOPER COMMAND LINE FOR MAC HOW TO
That's why i am asking how to connect SQL* Plus from SQL developer or other way.
Use one tool or use the other tool - using both will NOT work for what you are trying to do.
They are NOT designed to work together in the way you describe. Some sql*plus commands will likely NEVER be supported. You will NEVER be successful writing/testing scripts in Sql Dev that will actually be executed in Sql*Plus unless those scripts ONLY contain the simplest commands that are supported by Sql Dev. You can STOP all of those issues by using a text editor to write your scripts and sql*plus to test them. So please let me know how to connect sql*plus.to stop all these issues. To escape those errors adding below commands to my scripts but every time i am getting a new issue. Then you need to test those scripts BEFORE you move them anywhere to be used. To write scripts all you need is a text editor (notepad, wordpad, vi, etc). The newer versions DO include a scripting engine that can be run from the command-line but that app is NOT a 'duplicate' of sql*plus and has different commands. Sql developer is NOT a tool for writing scripts for sql*plus. But since you haven't shown us WHAT you are really doing or HOW you are doing it we can't really help with that.īoth Sql*plus and Sql Dev can connect to remote databases but they do it different ways. Most likely you are getting that 'unknown error' because you are NOT providing the correct parameters/command for connecting to that remote database. You can't - they are TWO DIFFERENT tools - you do NOT connect one to the other anymore than you can connect a wrench to a screwdriver. So no of differences are there execution of scripts in SQL Develoepr and SQL * Plus.Ĭorrect - as you were already told - those are TWO DIFFERENT tools designed to do two different jobs in two different ways. Blank lines also not consider in SQL developer, consider in SQL * plus.
SQL DEVELOPER COMMAND LINE FOR MAC UPDATE
Thanks for the update Selvakumar, But in SQL developer worksheet we will execute a single command in multiple lines, but in sql * plus will we will get an error.
0 kommentar(er)
