infoàtns Names, you can view Oracle's Tnsnames.ora.
Copy to Excel
Execute the SELECT statement in SQL window, after the result, right click on the data area, select Copy to Excel, you can copy the record of the data area to excel. But there are two points to note: First, field can not start with =, otherwise Excel will be mistaken for a function, and two, the number should not exceed 17 digits, otherwise the number of digits will be set to 0, but c
list options on the hook.9, formatted SQL (format)When you get a long SQL statement, you want to quickly see the logic, you can put it in the tool, format, and the logic of the statement is clear.10, the database automatically detect the connection situationBecause the database does not operate after a period of time, it will automatically disconnect, and then need to manually connect themselves, because o
Install Oracle11g + PL/SQL and win8oracle11g in Win8 (64)
Recently, Oracle11g is required and PL/SQL is used for management.
Software and Hardware Description
OS: Win8 64-bit operating
PL/SQL Developer usage tips, shortcut keys1, set the keyword automatic capitalization: tools->preferences->editor, will keyword case select uppercase. When you enter SQL statements in a window, the keywords are automatically capitalized, and the others are lowercase. This is easy to read code, and to maintain a good co
/ ahr0cdovl2jsb2cuy3nkbi5uzxqvbhf4mdqwnq==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/ Center "/>TNSNames configured properlyAfter multiple lookups, the reason is:specific reason: The 64-bit Win7 will install the 32-bit application into the program Files directory by default, and the two parentheses may be frustrating for Oracle. Change the
select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL/
replaced by select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements. Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit 1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL/
Inaccurate analysis and avoidance methods
1 Case visits
Hardware environment: IBM xseries 3650
Operating system: WINDOWS2003 Standard Version +SP02
Database version: Oracle9.2.0.1
Pl/sql Developer Version: 7.0.2.1076
As a result of business needs, first drop a partition table t_sms, and then rebuild this table, request table structure, index and so on exact
Use Instant Client to configure PL/SQL Developer, instantpl
Previously PL/SQL Developer was used to directly install the full version of Oracle Database on the local machine. One was easy to use, and the other was able to perform
select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL/
=" Wkiol1sb-m_jdeybaadzpylvfii232.jpg "/>Look at my Computer configuration first.PL/SQL Developer Version 10.0.5.1710Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)I have downloaded the following two versions, but will still pop up the above error:Instantclient-basiclite-win-x86-
the tables directory to expand, and the response rate after selecting my objects is in milliseconds. Setup method:The Tools menu –>brower Filters opens the Order window for Brower folders and sets "My Objects" to default.Tools menu –>brower Folders The few directories you regularly order (e.g. Tables views Seq Functions Procedures) Move up a bit and color-coded so that your average look-up time will be much shorter and try. Priority, from left to rig
, press the space, automatically replaced by select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following content:S=selectCopy code is saved to the ~/plugins directory under the PL
Occurs when connecting to a database with PL/SQL developer"Ora-12541:tns: No Listener" error.1. Check Listener.log logThe following error was found:Tnslsnr for 32-bit windows:version 10.2.0.1.0-production on 20月-September-2008 10:25:26Copyright (c) 1991, 2005, Oracle. All rights reserved.System parameter file is D:/ora
Tags: RAC blog file reference style environment Admin CSDN timeoutPrerequisite: The Oracle database has been successfully installed. Installation environment: Win7 64-bit Oracle installation version 11g 64-bit Question 1) Oracle comes with Sqldeveloper Let me enter the full path of the Java.exe and then report a warni
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.