It was not until the moment I received the invitation from Nokia that I realized that the time of the year had passed.
On the December 3 of last year, the QT developer Conference was held at the Radegast Hotel in Chaoyang, Beijing, and this December 12, the QT developer Conference was held at the Sofitel Grand Hotel in Chaoyang Wanda, Beijing.
Water Poor Place
Nokia bad Times, QT also can be called Life han
Pl/sql developer-newsseptember 2004-version 6.0.2 releasedenhancements Partitioned tables were not detected Corre ctly on Oracle8i Partitions tab page is visible when viewing a non-partitioned table Code Assistant did not describe mate Rialized views Code Assistant did not describe record types declared in another package Code Assistant could remove spaces Typed after a comma File-> the all could leads to invisible Confirmation dialog Font Bold Itali
Before you start
About this series
This six-part series on DB2 SQL Procedure Developer describes all the basic constructs and methods of SQL procedural Language, and explains how to use it in stored procedures, user-defined functions, and triggers, including error handling and deployment. Also describes some of the DB2 9.5 advanced features, such as optimistic locking, layered queries, and declared global temporary tables. This series will provide d
Tags: style io ar color sp on Art BS codeHow to efficiently debug an Oracle stored procedure, especially a parent-child mesh call stored procedure1. Set breakpoints at Oracle stored procedure where breakpoints need to be setHow to set breakpoints: Click a line at the beginning of a row of Oracle stored procedures to display aMiddle toA small red circle filled with white forks.How to cancel a breakpoint: click between 2, and then 3, press the Magnifier icon (start Debugger) or click the s
Tags: background database management tool Oracle ClientFor the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the teams. The level of integration between the different database products and the corresponding client management tools and different produ
The Oracle stored procedure needs to be written recently, as required by the company. I am a novice, after the completion of the writing of the stored procedure, it is necessary to analyze the execution time of each statement in the stored procedure in order toOptimize the entire stored procedure.Due to the use of Plsql Developer client tools, and most of the internet is introduced by the manual method of applying the profiler, using relatively chores
Plsql Developer Error message display garbled problemConnection environment:Win 7Database version:Oracle 11gSimulate an error, check the error prompt to show "????" "Garbled problem, as follows:Check:1, V$nls_parametersIn order to display Chinese, nls_language should be Simplified Chinese2. Enter the registration form to view the languageFind " run "in the " start " menu of the computer, then enter "regedit" in the dialog to open the computer registry
Tags: blog http java strong file art ar problemORACLE SQL Developer does not support Java versionsToday I open ORACLE SQL developer ready to start practiced hand. Did not expect to give a false hint . I have a Java JDK installed and a version 1.6. I might have chosen the Java.exe file below the bin directory, which was supposed to be the result of no problem or an error. The specific error message is as fol
Requirements: To connect to the Oracle database, do not want to install Oracle locally, too large, and account for memory, so use Plsql developer.Read a lot of blogs on the internet, Mom, is not clear, has been prompted to initialize the failure, is that oci,dll and then change a variety of configuration files, useless!Later, a colleague's Plsql Deveploper, his 9-point version, my 11-point, decisive change over,1. Install Plsql Developer, here is the
1. 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\)my jtds.jar free: http://download.csdn.net/detail/kk185800961/50801884. Add the connection to SQL Server and Sybase after completion. --------
Scenario Recurrence:Maintenance people want to use the Plsql Developer tool to view data from a table a year ago, with data in the table about 30W, because there is no business at this time, and the maintainer closes the application. When the query selects all the data is listed, the results are displayed to more than 3W, pop-up such as the following information prompt, display "result set exceeds the maximum length", at this time the maintenance pers
Label:1. Download instantclient-basic-win32-11.2.0.1.0(Oracle website:http://www.oracle.com/technetwork/ topics/winsoft-085727.html, 2:http://download.csdn.net/detail/czw2010/5732241) 2. Unzip the instantclient-basic-win32-11.2.0.1.0 and place it in the Oracle installation directory 3. Open Plsql Developer, select Tools , perference, Connection, configure the Oracle home and OCI Library item, as shown in: 4. Configure Environment variables:T
As Plsql developer did not provide 64-bit, so according to the information on the Internet to do a bit of finishing, sent up1. Download and install the Oracle 11g R2 64-bit, ignoring the hardware detection failure information when installing on the server;2, download the Oracle 11g R2 32-bit client, unzip it to the D:\app\Jack\product directory, and named Instantclient;Client download can go Baidu: Instantclient-basic-nt-11.2.0.2.0.zip must be able to
appropriate IP address to5. Place the modified Tnsnames.ora file under the D:\Oracle_Cleint\NETWORK\ADMIN folder.6. Environment variable settings (user variable, environment variable, "Properties", "My Computer," right), create a new user variable, variable name nls_lang, variable value simplified Chinese_china. Zhs16gbk7. Configure Plsql Developer, tools → preferences →oracle→ connection, complete Oracle home folder name: D:\Oracle_Cleint\OCI Librar
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 contains the SQL statements of this database, but also other databases, it must be in the SQL window to activate this function;Copy the entire SQL statement to the new SQL window: You
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
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.