Tags: plsql developer software WrapStatement ************************************************************** *********Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/39932149*************************************************************************************************************** *
This error message in different PL/SQL Developer version will appear, from the above detailed error message information can be judged that the cause of the error is not the tool itself.Here, take a detailed look at the three ways to deal with this small problem.1. First processing method (not recommended)This is the error in the error dialog box "Don t show this message again" option is selected, the next time will not be prompted this mistake.This me
1. Create a new table, business_copy, and copy the data from the Bisiness tableCREATE TABLE business_copyAsSELECT * from business;NOTE: This SQL statement simply creates the table and replicates the table's data, but does not copy the constraints of the table.2. Delete the table in PL/SQL developerFor example, delete a table business, perform a operation,1) DROP TABLE business;2) Locate this table, right-click and select Cross-boundary delete operation.3. Quickly create a table in PL/SQL
. Setup method: Right- --special copy 6. Custom shortcut keys Plsql developer has a lot of keys reserved for users to customize, which is very hight thing. Unlike the overbearing Word, basically all the keys have been pre-defined features, the change is very headache. Usually, after opening plsqldeveloper, the most frequently done thing is to open Sqlwindow and CommandWindow, the two operations have defined shortcut keys,alt+s and ALT + C, So take t
Label:
Log in to the database you need to back up using PL/SQL developer;
Select Tools, export user objects;
Select the object in the object list that needs to be backed up, then select an output file of SQL type, click "Export", this is just the export data structure;
Select tools, export tables;
Select the table in the list where you want to export the data, select "SQL Insert", select a file of SQL type, click "Export", this step
Original: SQL Drip 17-using the database engine stored procedures, System view queries, DBA,BI Developer Prerequisite Basics In the development process will encounter the need to figure out when the database was built, how many tables in this database, what is the length of the stored procedure, and so on, today, the process of working with some of the database engine stored procedures, system views and so on for the time being. The following knowled
Oracle's SQL Developer 4.0.3.16 is installed, but when connecting to a database, if you choose a connection type of "TNS" and cannot get a network alias, how do I set up to access the TNS file?The simplest way to set the TNS_ADMIN environment variable to point to the directory where the Tnsnames.ora file is located is as followsC:\users\konglb>set Tns_names=c:\oracleclient\oracle32\product\11.2.0\client_1\network\adminC:\users\konglb>echo%tns_admin%C:
Tags: plsql developer plsql case Conversion Plsql plsql Set shortcut plsql function shortcut keysChen Kozhan functionSelect the text you want to convert, right-->selection->uppercase or lowercase, either uppercase or lowercase.Set case shortcut keysIn the toolbar, tools->preferences, in the user interface option->key configuraction, and then in the list of item find Edit/session/uppercase or edit/ Session/lowercase, select, press the key of your keybo
When querying Oracle database using Plsql Developer and Dbvisualizer, query data is garbled in Chinese.Look at the database encoding formatSELECT * from V$nls_parameters;View the encoded value as WE8ISO8859P1. and the computer environment variable Nls_lang value is American_america. ZHS16GBK. Change toAmerican_america. It's good to restart the tool after WE8ISO8859P1. If you do not have this environment variable, you can create a new one and change th
Original Oracle SQL Developer useComparison:Plsqldev: Third-party, fast startup software, slow execution of SQL queriesSqldeveloper:oracle company, slow startup software, fast execution of SQL queriesDisadvantages:Every once in a while (about 10 minutes), will be disconnected, need to reconnect, bitter force!Ask for help: Hope to know the warrior, tell me a soundObjective:To connect a local Oracle Server service-side instance using SqldeveloperUsing S
After the Oracle database is installed, start the database as SQL Developer: The result is a small box prompting you to enter the full PathName for Java.exeFor this workaround:Locate the Java.exe file under the Oracle path that you installed, and locate the following two paths of Java.exe:First one: D:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\java.exeThe second one: D:\app\Administrator\product\11.2.0\dbhome_1\jdk\bin\java.exeTry to put o
I was not clear about Apple ID and Apple developer account. Just know Apple ID can download a variety of apps in the App Store. Then Apple developer account needs to spend 99$ to register, today suddenly found that I am ignorant. In fact, the Apple developer account can be registered for free. And the Apple ID can be the same as the
Apple Developer Account Registration process is more complex, and everyone to share the process and details, so as not to take a detour.1. Login to the Apple Developer websitehttps://developer.apple.com/programs/ios/2. Click the "Enroll Now $99/year" button (e.g.)3. Click on the button "continue" (e.g.) on the intro page that pops up.4. The next page is the option to register as a
1 About RICurrently, using a browser to access a webpage on a mobile phone does not make it easy to debug the page language. Mobile phone screen is relatively small and inconvenient to operate, directly on the phone web data debugging is not very realistic.Therefore, we use technology to separate the debugging information of the mobile phone, and realize a development tool--remoteinspector (RI) that can be used to debug a small screen and a low-profile mobile browser on a large screen and a high
Finally, I found the official documentation. Generally, the search engine seems to be unable to find the lifeary developer mode and developer. I have always wanted to switch to the development mode, but I don't know how to switch it. After reading the documentation, it is actually very simple.
You can debug front-end JS after enabling it. This is very useful.
Do you want to develop liferay resources witho
The following tips only apply to PL/SQL developer 6 and later versions. Version 5 only has some features.1. Right-click the menuRight-click an object name in each text editing window in PL/SQL developer (PLD), such as SQL window, command window, And porgram window, A menu containing the operation object command is displayed, which is called the Right-click menu. For example:Objects can be tables, views, syn
The new version of ogengine is released to promote the developer service platform.
On Saturday afternoon, 9.27, ogengine and GDG held a developer conference in Shenzhen hi-tech park to attract mobile game developers and Android Developers.
The Conference was themed with "mobile game engine and game development" and divided into four phases: Introduction to ogengine and release of the new version, and exper
Note: This article is the fourth article on chrome Developer Tools translation.
See https://developers.google.com/chrome-developer-tools/docs/resources for more informationChrome Developer Tools: Resources panelchrome Developer Tools: Resource Panel
TheResourcesPanel lets you inspect resources that are loaded in the in
Ajax is the most popular technology on the Internet today, because it is called the cornerstone of Web 2.0. Unfortunately, creating an Ajax application
ProgramIt is not easy, especially when you need to integrate with other frameworks, such as JavaServer framework (JSF ). Fortunately, IBM Rational application developer V7 provides Ajax functionality for JSF components, which simplifies such tasks. This article describes how to use Ajax and JSF in I
Command-line tool Devtool, which runs the node. JS program in Chrome's developer tools.The following records show how breakpoints are set in an HTTP server.The tool combines the functions of node. JS and Chromium based on Electron. It is designed to provide a simple interface for debugging, analyzing, and developing node. JS applications.You can use NPM to install it:NPM install-g DevtoolIn a way, we can use it as a node substitute for shell commands.
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.