http: instaling.pl login

sponsored links

window to use pl / sql login problem

Global database name, database name refers to the complete global database name such as orcl.zh.org sid is orcl zh.org is its domain The database is identified by its global database name. Global database name consists of two parts database_name.data

PL / SQL can not login Oracle

Original Address: http://zhidao.baidu.com/question/202591604.html Land User Name: XXX Password: XXX Database: Database name _172.16.1.104 Probably because the Oracle10g and 9i installation directory structure has changed, you need PLSQL Developer to

Install only the Oracle client to use PL / SQL developer login oracle server

1, download oracle_client to the local. 2, install the client, select 178M of that is to install only the client 3, the installation is complete in the command line, type sqlplus, if you can use that installed the 4, and now, of course, can not conne ...

Free installation of Oracle client software - using the pl / sql login configuration

PL / SQL I first use of June first, nothing will. Of people would not even have to use and configure the blind chaos. Now the PL / SQL Configuration Summary down: 1. Download the Oracle Client Package. From http://www.oracle.com/technology/software/tech/o

PL / SQL Developer login password save

1 Open the menu 'tools' ->' preferences' 2 In the window 'oracle' part in the 'Logon History' in the 'store with password' option can be selected 3 out of PLSQL, the login time to choose 'username' s

oracle 11gR2 ORA-01017 PL-SQL user can not login

oracle 11gR2, recently encountered such a problem, by toad, pl / sql, always newly created user can not log in, log in system and sys no problem, every time you log a new user, always prompted ORA-01017, this problem was wrong user name or password t

Client configuration oralce pl / sql

Today, the work of colleagues in the transfer of separation is encountered, pl / sql data connection closed. Colleagues said it was expected to open port network does not give you. He sent for me to open ports, network management after open port. Or the c

PL / SQL Developer Tips

PL / SQL Developer Tips 1, PL / SQL Developer remember the login password when using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 -> to

SSH login tool commonly used commands

As for the foreign host, then SSH login tool is certainly essential, here a list of some commonly used SSH commands to use for future reference. First of all we have to know what the shell. The main interface with the operating system is called the e ...

Free installation of Oracle client to use PL / SQL, TOAD FOR oracle connection manager such as Oracle9i, 10g

Free installation of Oracle client to use PL / SQL, TOAD FOR oracle connection manager such as Oracle9i, 10g As we all know, Oralce client too few megahertz, there are many DIR-line treatment. Here the use of official ORALCE handling kit Instant Client Pa

User right Log PL / SQL Dev

[Reprinted] http://hi.baidu.com/xxoo_0/blog/item/67bde11136923b085baf5301.html Login PL / SQL Developer Always prompted: You are not allowed to use PL / SQL Developer on this database. You do not have the System.Logon privilege in the PL / SQL Develo

PL / SQL Developer practical skills

Oracle database is believed to have a lot of companies build their business-critical support for the importance of the background, is often used by many developers back. However, Oracle provides its own set of client-side tools are not useful, a grea

PL / SQL Developer Skills

1, PL / SQL Developer Login Password Remember Using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Oracle-

PL / SQL tool to connect the remote ORALCE database approach

1, using ORACLE NET MANAGER tools 1) Open ORACLE NET MANAGER 2) increasing the "service name" NET service name first: fill out any The second step protocol: If the remote machine to connect ORACLE, select TCP / IP (internet protocol) The th

Oracle Database 11g PL / SQL Programming 10.1 Introduction trigger

http://sns.linuxpk.com/space-52196-do-blog-id-16060.html Database triggers are special stored procedures. Usually do not call them directly, instead of triggering the events from the database. Them in the implementation of command and the implementation o

PL / SQL Developer Tool Tips

1, login by default automatically selected My Objects By default, PLSQL Developer login, Brower Lane will choose All objects, if you logged on user is dba, to expand tables directory, normally have to Wait a few seconds, and select the My Objects mil

PL / SQL installation and configuration

pl / sql installation: 1, in the oracle client installation directory D: \ oracle \ product \ 10.2.0 \ client_1 directory New directory network, the network admin directory create another directory file in the admin directory under the new tnsnames.o

pl / sql to access remote database

/ / Database configuration file directory E: \ oracle \ ora92 \ network \ admin \ tnsnames.ora (Database name) FWMSDB = (DESCRIPTION = (ADDRESS_LIST = server ip (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.6.40) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE

pl / sql developer of the character set issues

Today install pl / sql developer, connect the remote database, the query results after the garbled. . . Resolve as follows: Create a file named "NLS_LANG" the system environment variables, setting the value "SIMPLIFIED CHINESE_CHINA.ZH

PL / SQL Developer with ten tips

(1) how to save login information? (A) in the toolbar of the [Log on] down the button to select [Configure ...], then the Definition tab of the [Store history] and [Store with password] check box is selected and saved more than two . As long as the i

PL / SQL Developer of the commonly used techniques

1, PL / SQL Developer remember the login password in the use of PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer7.1.2 -> tools-> Preferences-

pl / sql developer 7.1.4 tips

pl / sql developer 7.1.4 tips 1, according to F8 SQL statement execution of the current line Preferences-Window Types-SQL Window - AutoSelect statement 2, the result set shows the number of specified Preferences-Window Types-SQL Window - Records per Page

PL / SQL Developer with skills in common

[Align = left] 1, login by default automatically selected My Objects By default, PLSQL Developer login, Brower Lane will choose All objects, if you logged on user is dba, to expand the tables directory, normally need to Wait a few seconds, and select the

PL / SQL Developer of the problem: Initialization error Could not load

Today, the machine with the server is located, so do not download the Oracle client, but directly open the PL / SQL, or when there are several Small problem, first Initialization error Could not load Specific methods are as follows: Start PL / SQL De

PL / SQL shortcut keys

PL / SQL collection of shortcut keys 1, the default login is automatically selected My Objects By default, PLSQL Developer login, Brower Lane will choose All objects, if you logged on user is dba, to expand the tables directory, normally need to Wait a fe

Oracle client is not installed the circumstances under which pl / sql developer

Under normal circumstances, with the PL / SQL Developer Connection is the need to install Oracle Oracle client software, which means your hard drive will be occupied the space of about 1G-2G, for the Windows operating system, you will be more number of bo

pl / sql developer navigation window

Come the new installed pl / sql developer did not found a navigation bar, opened the window a ghost do not know how many O (∩ _ ∩) O ~. Window switch inconvenience, Internet search, I need so the whole: tools -> window list In tools-> preferenc

[Transfer] pl / sql developer experience

1. PL / SQL Developer remember the login password in the use of PL / SQL Developer, the In order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer-> tools-> Prefere

PL / SQL Developer with skills

1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-

Oracle 10g green client plus PL / SQL Developer-Oracle client set up and convenient to use the environment

To do an entire summer in an Oracle-based data processing program. But has not found a suitable artificial laboratory database to facilitate access method. Coolest when I practice is to write a program to connect the database using JDBC want to form their

PL SQL connection oracle (10g) database problem

windows7 PL SQL tool used to connect remote Oracle10g database, always pop up a small window, the white does not have any message, click "OK" and then back to the login screen, I see the network has a wireless connection there is a wired co

connect to a remote oracle 10g pl sql

Premise has been installed in the machine oracle 10g server. Or two machines were installed in the oracle server, the client A full client, plsql connect 1 Download 10201_client_win32.zip (oracle10.2g full client), all the way next installed, 2 Open the c

Oracle Database 11g PL / SQL Programming Overview 10.1 Triggers

http://sns.linuxpk.com/space-52196-do-blog-id-16060.html Database triggers are special stored procedures. Usually do not call them directly, but to the events triggered by the database. They execute the command and the implementation of the action between

Oracle uses the skills and PL / SQL Developer configuration

PL / SQL Developer with skills 1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 ->

pl / sql developer of the character set problem

Today install pl / sql developer, connect remote database, the query results after the garbage. . . Resolved as follows: Create a file named "NLS_LANG" system environment variable, set its value "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

(R) PL / SQL Developer with skills

1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Or

racle 10g green client plus PL / SQL Developer-Oracle client set up to facilitate the use of the environment

Today in Win7 on the configuration a bit and found always wrong, the original online information is a small configuration file to write the parentheses, sweat, I used to write the connection string parameters compare, and found that the final surface

10 years time pl / sql Programming Guide Qiaoxia most of the examples above (spare)

declare cursor emp_cursor is select empname, salary from employee for update; emp_record emp_cursor% rowtype; begin open emp_cursor; loop fetch emp_cursor into emp_record; exit when emp_cursor% notfound; if emp_record.salary <2000 then update employee

PL / SQL Developer commonly used techniques

1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer7.1.2 -> tools-> Preferences-

PL / SQL configuration

Transfer http://foolraty.iteye.com/blog/520089 PL / SQL configuration: Note: Please download the latest oracle instant client .. some pl / sql Developer does not support the old version of .. There is the original case had installed oracle client .. then

An official free version of Oracle client, use the PL / SQL Developer Connection Oracle__ own summary

Thanks: jslfl, refer to: http://jslfl.iteye.com/blog/788831 A security official free version of Oracle client, connect to the database method 1, http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html download Instant Client P

PL SQL Developer to create stored procedures and problems encountered and solutions

1. After login PL SQL Developer , On the left to find the Procedures, right-click pop-up submenu , Click new 2. In the dialog box, enter the stored procedure name and parameter name. Parameter type , Then click OK: 3. Then the stored procedure code input

PL / SQL Developer with skills summary (rpm)

The following tips only for PL / SQL Developer 6 or later, version 5 only one part of the property. 1, right-click menu in PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porg

PL / SQL Developer with skills (turn)

1, right-click menu In PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porgram Window, right-click an object name will pop up a menu containing the command operation object, w

pl / sql import and export

Summary and some of their own small record Export table structure: Tools -> Export User Objects (export user objects) -> choose to export the table (including the Sequence so )-->. sql files, sql files are exported Export table data: Tools -

Not to install oracle client in the case using pl / sql developer

Normally, with PL / SQL Developer to connect Oracle is a need to install the Oracle client software, which means your hard drive will be about 1G-2G occupy the space for the Windows operating system, you will be more Some boot from the start of the servic

Oracle client tools use PL / SQL Developer-User object comparison

In the actual project implementation process, from testing to production, in order to ensure that the test used when the database table fields, indexes, views and other elements of production consistent with the need to conduct some more. This can us

Oracle dba user can log in with, but not normal login permissions!

Today, the project encountered a problem, I create a new user, then assign him connect, dba, resource permissions, then the user Ob10 in the normal privileges can log in, then I pl / sql in The lack of prompt access to normal user name or password is

PL / SQL Developer practical techniques (transfer)

Oracle database is believed to have become the key to many companies build their own business, an important background support, but also many developers often use the background. However, Oracle provides its own set of client tools are not very good,

PL / SQL (oracle) 9_ trigger

First, the trigger concept: (Trigger): Is a named PL / SQL block, is automatically triggered by specific events. Triggers can not receive parameters. Is based on the tables, views, programs, database level. Second, why use a trigger. Can usually achi
Recent
Recent Entries
Tag Cloud
Random Entries