Properties {name: "AppleScriptNotebook1"}end ifset name of Notebook "AppleScriptNotebook1" to "AppleScriptNotebook2" --WARNING There is no Confirmation!delete notebook "AppleScriptNotebook2"--------------------------------------Create , rename, and delete tagsif (not (tag named "AppleScriptTag1" exists)) Thenmake tags with properties {name: "AppleScriptTag1 "}--Create a Sub-tagmake tag with properties {name:" AppleScriptTag2 ", Parent:tag named" AppleScriptTag1 "}end ifset name O F Tag "AppleSc
After migrating to the Mac platform for Development, a series of preparatory work is needed to make our work smoother.1. Installing the Homebrew Package ManagerThe Apple system comes with a package manager, but it's not very useful. Now, the more popular is homebrew, very easy to use, only a brew command can be easily implemented software installation and uninstallation operations, similar to the Apt-get tool in Ubuntu. Open terminal and enter the fol
One: Scenario:
You need to install command line tools when using a git;xcode4.6 environment under a Mac, but after installing XCODE5, you don't need to install command line tools, which are already integrated by default; But I did it first. xcode4.6 later installed XCODE5 that is, I have two versions of XOCDE installed on my Mac, but when I use git under the terminal, the following error occurs:
Two: Wron
Tags: col program configuration SQL query field positioning Rod AC MVCThese days encountered two problems, are very wonderful, distressed for three days, the final positioning out.Problem one, inserting data through PL/SQL developer to a remote Oracle database server, querying data through PL/SQL
10 types of Java developers often encounter errors when writing SQL statements, and 10 types of java developer SQL
The degree to which Java developers can coordinate object-oriented programming thinking and command line programming thinking depends on their ability:
Tips (anyone can write code in the command line format)Dogma (some people use the "mode-mode" meth
PL/SQL Developer Quick action: show invisible characters Display historical SQL statements copy entire statements of the Windows to a new SQL windowDisplay invisible characters: You can display the blank space, carriage return;Show History SQL statement: Ctrl+e, not only con
The key to performance optimization is to find the right direction, for example, for a PL/SQL code, we think it is slow to execute, but in the end it needs a measurable tool to analyze, and we sometimes like to leave debug code in it, like using dbms_utility.get_ Time is spent on the execution of the statement, which can be cumbersome if the code is large.PL/SQL Develop
database. Wait a moment and prompt that the export is complete. Then run the following command to import data:
>oracle_ctl[oracleusername][password]
You do not need to specify the database name or the like here, because it has already been specified in the script.
Wait for a moment after the import is complete.
At this point, the knowledge about migrating SQL to Oracle by SQL
From: http://blog.csdn.net/kk185800961/article/details/86023061. Start with only Oracle and access connections2. Open Oracle SQL Developer:Tools--> Preferences--> Database--third-party JDBC driver--Add driver entries3. Automatically loaded into the directory, Jtds.jar downloaded to put here.(My path: C:\Documents and settings\administrator\application data\sql developer
Oracle's official SQL Developer comes with Oracle migration Workbench.
What is Oracle SQL Developer? On the official page, this is how it is presented:
Oracle SQL Developer is a free and fully supported graphical too
different Object types.
4. All SQL statement characters are in uppercase I think this is a good habit. The core of the information system is the database. When the system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful.SQL statements in uppercase cannot completely solve this problem, but it
Http://hi.baidu.com/yunfanleo/blog/item/fa65fcfd91916346d7887d25.html
PL/SQL developer
PL/SQL developer is an integrated development environment dedicated to the development of Oracle database storage program units. Nowadays, more and more business logic and application logic are turning to Oracl
S =Select T. * From TW=Whereb=Between andl=Like '%'O = orderInsw = in (select a from a where a) SW=Select T. * from t where TSC *=Select count (*) from TST= Select T .*,T. rowid from TF=For updateu= Update t set T. where T
1. Copy the shortcuts.txt file to the X: \ Program Files \ PLSQL developer \ plugins directory. Pay attention to the permissions for win7.
2. Choose tools> perferences> editor> autoreplaces from the menu.
3. Restart PL/
different Object types.
4. All SQL statement characters are in uppercase I think this is a good habit. The core of the information system is the database. When the system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful.SQL statements in uppercase cannot completely solve this problem, but it
passwords can be a problem for data security.But if it is the development of the library, the password can even be the same as the user name, each time to enter a password is meaningless, you can consider let Plsql developer remember the password.Location: Tools menu--preferences--oracle--logon history--store with password3, double-click to display table dataPlsql developer The default response when you do
Oracle SQL Developer is a free integrated development environment produced by Oracle Company. Oracle SQL Developer is a free, open-source, graphical tool for developing database applications, using SQL Developer to browse database
Label:1, PL/SQL developer remember login passwordWhen using PL/SQL developer, you want PL/SQL developer to remember the username and password to log in to Oracle for your convenience; Setup method: PL/
The PLSQL installation directory contains the specialcopy directory and Java. Copy, C ++. Copy, and so on,
Add a file: java4stringbuffer. copy with the following content:
; PL/SQL developer specialcopy Definition; ; ; ;# Define "= \"# Define \= \\# Define char (9) = \ tNew stringbuffer (". Append (". Append ("
Write such a statement in PLSQL:
Select O. COMPID, O. pcompidFrom basic_organization oConnect
The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered that the PL/
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.