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 a
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
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 maxim
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 var
When using PL/SQL developer, the query out of the text field is garbled, because the database number format and PL/SQL Developer encoding format is not uniform caused.I. Viewing and modifying the Oracle database character setSelect Userenv (' language ') from dual;--query result: simplified Chinese_china. al32utf8--Modifying the Oracle Database Character set: (In SQL Plus) sql> conn/as sysdba;sql> shutdown
v$session is not a specific view with the same name. Otherwise you will receive the following error.[Email protected]> Grant Select on V$session to User_sec;Grant SELECT on V$session to User_sec*ERROR at line 1:Ora-02030:can only select from fixed tables/viewsThe correct authorization method is as follows:Sql> Grant Select on V_$session to User_sec;Sql> Grant Select on V_$sesstat to User_sec;Sql> Grant Select on V_$statname to User_sec;2) You can use the "simple Brute" method below to deal with
; // Create user name identified by "RSGL" //create password default tablespace rsgl//default tablespace temporary tablespace temp //temporary table space (default) profile default //default permissions (assigned below) Quota Unlimited on rsgl; //the user's quota in YDRSGL table space is unlimited --Grant/revoke role privilegesGrant DBA to RSGL; //Assign Administrator privileges--Grant/revoke System privilegesGrant unlimited tablespace to RSGL; //Open all tablespace to this user4.
tables= table name w3sky Note: The table name to be recovered refers to the table name of the backup. Recovery is the accumulation of data on the basis of the original table. No special instructions are allowed on the client to perform a recovery command to a user of a database on all the tables of a user to another database under example exp Userid=system/manager owner= UserName1 file=expfile.dmpimp userid=system/manager fromuser=username1 touser=username2 ignore=y file= expfile.dmpw3sky all t
procedures see the reference blog: http://blog.csdn.net/singit/article/details/708284001. Problems occurred during installation1. The prerequisite check failed because the operating system did not turn on the default share. Workaround Reference Blog: https://www.cnblogs.com/xiaoxiaoweng/p/7277969.htmlThird, the download and installation of Plsql, this simple straight all the way to install down on the line
No other software, only the browser itself "developer Tools" can download the network video directly, do not believe it. Try it together.
First, download the network video using the browser developer tools
IE 9 Find "hang" link to start
IE 9 Browser New developer tools, yo
Microsoft has just revised its Windows Developer Center and released the Developer Preview for Windows 8. You can download and install it as you like.
This release of Developer PreviewOnly a Windows 8 pre-test version for developers, May change without notice, including adding and deleting functions. Microsoft specif
Microsoft Visual Studio 11 Developer Preview (ISO)
Http://www.microsoft.com/download/en/details.aspx? Id = 27538
Microsoft Visual Studio 11 Developer Preview (Web installer)
Http://www.microsoft.com/download/en/details.aspx? Displaylang = en id = 27543
Microsoft Visual Studio team Foundation Server 11
automatically enter the user name and password (unless the form is cleared), but it takes a long time, the password will be forgotten, and Web Developer will have this function. After clicking form-show password, the password will be displayed, which is very convenient.
In addition, because the official website does not have a Chinese version by default, I found a Chinese version of the latest Firefox plug-in on the Internet. It is very good. Please
PL/SQL Developer's experience in connecting to Oaracle11g64-bit System in 64-bit Windows 7, download from Windows 7
PL/SQL Developer's experience in connecting to Oaracle11g64-bit System in 64-bit Windows 7I. Problem phenomena and SolutionsSymptom:1. PL/SQL cannot log on to the 64-bit Database2. Enter Chinese in PL/SQL developer. After saving, the Chinese character becomes '?? 'Such garbled characters3. Aft
more information about Windows Phone 7.8, see the Windows Phone developer documentation.
System Requirements:
Supported Operating Systems: Windows 7, Windows 8, Windows 8 pro, and Windows Vista
• If you have installed Windows Phone SDK Update for Windows Phone 8.0 on a computer with Windows Phone SDK 7.8, see Windows phones SDK 8.0 system requirements.
• Windows 8 64-bit (x64) Client Version, hardware: 6.5 GB available hard disk space, 4 gb ram, 64-b
Firefox Developer Edition official website can not download
https://www.mozilla.org/zh-CN/firefox/channel/#developer
Whether it's Chinese or English, it's not all,Copy address with Thunder also can't under, no resourcesI can't search the seeds.Seek the great God to solve
Reply content:
Firefox Developer Edition o
After the link is copied, the Thunder can be opened to download! Please download it according to your phone model. Do not need Udid binding, developer account, download directly after the upgrade.Please follow your own phone model will link copy open Thunderbolt click Download
J. D. Meier, Principal PM, MicrosoftHttp://blogs.msdn.com/jmeierHttp://GettingResults.com
Introduction
Welcome to the Windows Azure Developer Guidance Map! This map is a temporary lidated index of Windows Azure content collections for developers. the primary content collections included in this map are: Code Samples, How Tos, Videos, and Training. within the content collections, the resources are organized by Windows Azure features, common tasks, and
Software developer roadmap: download mini ebook from apprenticeship to master-Linux general technology-Linux programming and kernel information. for details, see the following. Software developer roadmap: From apprenticeship to master
By Dave H. Hoover/Adewale Oshineye
Translator: Wang Jiangping
Introduction:
As a software
Microsoft developer series lecture download Date: 8/4/2004 | update date: 8/5/2004 content on this page
1. Windows Forms Application Development
2. Delegates and events
3. xml and soap
4... Net advanced database applications: data caching, connection pool management, and distributed transactions
5. advanced Web service applications
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.