PL/SQL相关方便性设置
PL/SQL的一些方便性技巧列举如下:
1.写好的SQL代码转成自定义格式的JAVA(或其他)代码,可减少手工拼凑的重复工作。例如：
A.创建文件Java_Query.copy的文件，在文件中贴上如下代码：
|
;PL/SQL Developer SpecialCopy definition
;<LINE_1> for first line
;<LINE_*> for all other lines
;<LINE_N> for last line
;
#define " = \"
#define \ = \\
#define char(9) = \t
StringBuilder sql = new StringBuilder();
sql.setLength(0);
sql.append("<line_1>");
sql.append("<line_*>");
sql.append("<line_n>");
|
B.将文件拷贝到%PLSQL_STEUP_PATH%/SpecialCopy
C.在PLSQL中讲写好的SQL语句选中,[右键]>>[Special Copy]>>[Java_Query],如图:
D.按CTRL+V(复制)就可以看到结果了，可以把相关代码复制到程序中即可.
2.自动替换,快速输出查询、更新等语句.
A.选择PL/SQL菜单[Tools]>>[Preferences..],如图设置:
B.这样，在PL/SQL中输入S+空格,则可以出现SELECT T.*,T.ROWID FROM ,方便开发调试，减少打字时间.
2021年3月02日 01:05
Fantastic blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any suggestions? Many thanks! 123movies
2023年1月21日 01:25
It's great to see that PL/SQL is embracing modern development techniques to streamline processes. The ability to convert written SQL code into a custom format, such as JAVA, can save real properties Katy developers a lot of time and effort. This convenience setting ensures that code is written quickly and efficiently, minimizing the need for manual patchwork. It's clear that PL/SQL is committed to making coding as straightforward and efficient as possible.
2023年7月18日 02:41
Diese Funktion ist auf allen Android-Smartphones verfügbar, einschließlich Samsung, Redmi, REALME und OPPO. Das Sperren des „ Startbildschirm-Layouts “ verhindert das unerwartete Entfernen eines App-Symbols vom Startbildschirm Ihres Mobiltelefons. startbildschirm layout gesperrt Wenn Sie diese Option deaktivieren, werden alle Apps auf dem Startbildschirm Ihres Android-Geräts entfernt. Es ist bereits standardmäßig deaktiviert. Viele Menschen sind sich dieser Möglichkeit nicht bewusst.
2023年8月22日 00:15
CBSE Textbooks for Class 1 English, Hindi, Mathematics, Science, Social Science, and Sanskrit are available in this webpage. You will get the Download links of CBSE 1 Class Textbooks 2024 Students 1st Class which will help to prepare Final Examination Prepare of CBSE Board. Students your Textbooks online provide our website, Visit our web portal Download CBSE 1st Class Books 2024 Pdf links CBSE 1st Class Syllabus 2024 CBSE 1st Book 2024 are Quite Important when we talk about the Central Bard Exam as these 1st Class book are Prepared as per the Syllabus Prescribed for CBSE Exam. so the NCERT 1st class Books 2024 can be Considered as the Complete Preparation Material for the Exam.
2024年1月11日 04:10
Bonjour On dirait que les thèmes de ce concis debrieffing requierent d’avantage de valeurs; Votre tournure peut paraitre recevable or je ne defend pas les différents avis plus anciens! il faudrait ajouter quelques valeurs pour plus de professionalisme! Merci google doc dark mode