oracle sql developer tool tutorial

Windows 7 64-bit Oracle SQL Developer tool, win7developer In the process of using Oracle SQL, a lot of reference materials, counseling institutions, and various books are mostly explained using PL/

path and tns_admin environment variables)For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:Sql> Select Userenv (' language ') Nls_lang from dual;Nls_lang----------------------------------------------------Simplified Chinese_china. Zhs16gbkRight-click My Computer-Properties-advanced-environment variables-system environment variables:1> Select "Path"-click "Edit" to add "D:\

1) Install Oracle 11g 64-bit, I use the version: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html2) Install the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0) as: Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version,

Label:You can also use PL/SQL CreateDirectory "image" as 'e:\';--"image" to bring double quotes, many online without, I test error, and, ' E:\ ' is the server directory, non-local directory. User Authorization required: Grant create any directory to username; Declareb_file bfile; B_lob blob; begin Insert intoTB_SJ (SJBM,SJMC,RKSJ,XGSJ,GSBM,SJDATA,LBBM)Values(1,'Figure 2-1 C1SR sedimentary facies plan of ASA key area', Sysdate,sysdate,2, Em

Tags: des c a file data usageToday, we are prepared to further refine the functionality and make it more automated, based on the gadget model_sql written @zhangkai05. Convenient for modeling personnel to develop ETL tasks.After the source code changes, it is published to Git (URL address) and is gradually perfected.Describe the status quo and problemsTeam Data Warehouse modeling began using the Oracle SQL D

Tags: http io sp CTI on C SQL R BSWhere is the Oracle SQL Developer connection information saved?Oracle SQL Developer connection information is missing after switching the logged-on use

PLSQLPL/SQL developer is an Oracle Database DeveloperProgramIntegrated Unit Development Environment (IDE). With PL/SQL developer, you can easily create the server part of your client/server application. So far, you can do the following in the worst case:• Use a text editor t

Client directory (E:\app\qingx\product\11.2.0\client_1). OCI Libaray Path is Oci.dll (E:\app\qingx\product\11.2.0\client_1\bin\oci.dll) of the Oracle client directory. Click "OK" and now the configuration is complete, here is the time to wait for a miracle. Exit PL/SQL Developer. 4. Verifying Oracle ClientOpen a new

installation profile, including the specific installation path of the client software, the product language, the space required for installation, and the client components that are specifically installed, and then click Install to confirm the error. Once the software is installed, the Configuration Assistant option is also entered, and the client's configuration assistant only needs to configure the network section. If no special needs, choose to perform a typical configuration, click Next to

1 Installation Configurationhave been using Toad to manage the database, today, a small study of SQL Developer tools, after the installation of ORACLE, the default installation of SQL Developer, the installation directory is $oracle_home/sqldeveloper, The first time you star

scenario is this:Project Architecture is SPRING+MYBATIS+TK.MYBATIS+SPRINGMVCUsing the MyBatis Extension tool Tk.mybatis eliminates the usual additions and deletions to redundant code, because the MyBatis syntax is not very familiar with, has been suspected to beUsing MyBatis queries, and querying data in t_product_info tables using PL/SQLThe main possible cause should be inconsistencies in data structures before and after the insert. Resolution by de

From: http://livenzhao.spaces.live.com/blog/cns! 6e0000be9f6ddd872! 595. entry· PL/SQL Developer skills 1. PL/SQL Developer remember the Login Password When PL/SQL Developer is used, PL/SQL