本文介绍了SQLDeveloper是否支持执行脚本?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

限时删除!!

我今天尝试按照一些说明进行操作,它以评论开头

I was trying to follow some instructions today, and it starts with the comment


REM  In SQLPlus I manually copy in each line and execute it.

很好,我没有SQLPlus,我有SQLDeveloper.粘贴的行的类型为:

That's nice, I don't have SQLPlus, I have SQLDeveloper. The lines that were pasted in were of the type:


@\\server\dir\dir\dir\commandfile1.txt;
COMMIT;

...等等.

当我在SQL窗口中尝试该操作时,它不喜欢它.我打开并手动粘贴了命令,对此也不满意. (我是否提到我对这个应用程序或Oracle不太满意,但是今天其他人都不在吗?)那里的文件以如下代码开头:

It didn't like it when I tried that in a SQL window. I opened up and pasted in the commands by hand, and it wasn't happy with that either. (Did I mention that I'm not so good with this application nor Oracle, but that everyone else was out today?) The files there started with code like:


rem
set echo on
rem
execute procedure_name ('parameter1', 'parameter2');

一个同事确实有SQLPlus,我们一起解决了它.但是,有没有办法让我使用SQLDeveloper做到这一点,所以如果他也不在外面,我不会被困住?

A co-worker did have SQLPlus, and together we got it resolved. But, is there a way for me to do this with SQLDeveloper, so I'm not stuck if he's out too?

推荐答案

要在SQL Developer中运行脚本,

To run scripts in SQL Developer:

@"\Path\Scriptname.sql"

(只有空格时才需要引号)

(You only need the quotes if there are any spaces)

您可以设置默认路径:工具菜单>首选项>数据库>工作表>选择默认路径以查找脚本

You can set a default Path: Tools menu > Preferences > Database > Worksheet > Select default path to look for scripts

这篇关于SQLDeveloper是否支持执行脚本?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

1403页,肝出来的..

09-07 20:08