oracle sql developer 11g

1. the downloaded Oracle SQL Developer, rpm file,: http://www.oracle.com/technology/software/products/ SQL /index.html 2. install sun's jdk1.6, if installed, skip (linux mint 12 is installed by default) command: sudo apt-get install sun-java6-jdk www.2cto.com 3. oracl SQL De

There are two types of data type conversions for Oracle: Implicit conversions and explicit conversions. Try to use explicit conversions when you use them.Implicit conversions are typically Varchar2 or char conversions to number and date, or vice versa. Example,hir_date> ' 1-jan-2014 ' string is implicitly converted to the date type, and select ' 53.5 ' +23 from dual is implicitly converted to the number type for the string.An explicit conversion:An ex

Sort after adding nulls last in descending order, put null in the finalSelect To_char (sysdate, ' Q ') from dual;Dual pseudo-table public synonym because it has a record for easy readingSelect RowNum, ' A ' | | Rownum,mod (rownum,2) from dual connect by rownumSelect Rownum,to_date (' 2016-05-01 ', ' YYYY-MM-DD ') from dual connect by rownumSelect sysdate,sysdate+1/24,sysdate+1/1440 from dual;Select To_char (sysdate, ' Fmyyyy-mm-dd h24:mi:ss ') from dual;Select 100+NVL (null,0) from dual;Select c

syntaxes: case when field name = ... then ... (infinite access) else ... end Case field name when ... then ... (infinite access) else ... end Don't write End is a pig, forget n+1 times Decode () function The decode () function is somewhat similar to the use of Case...when Decode (field name, ' Value 1 ', ' corresponding value of value 1 ', ' Value 2 ', ' value 2 corresponding value ' ... (Infinite Connection) ..., ' Default ') Vm_concat () function Select Sname,student.sno,wm_concat (CNO) fro

How Does Oracle SQL Developer configure TNS and ipvtns? When oracle SQL Developer 4.0.3.16 is installed, if the connection type is "TNS" and the network alias cannot be obtained, how can I set it to access the TNS file? In

1:oracle SQL Developer 4.0.2 download Link:Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html2: The downloaded file is sqldeveloper-4.0.2.15.21-1.noarch.rpm, RPM installation package cannot be ins

Get ready: PL/SQL Developer: I'm using plsqldev1005 (32-bit) Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit After the installation is successful, you need to configure the environment variables:Tns_admin environment variable, similar to: C:\app\Lzj\

Oracle SQL Developer 3.1.07.42 is installed in Linux Mint 12 (see). It feels good to connect Oracle, Mysql, and SqlServer ......., but there has always been a problem, that is, when the mouse is clicked, the mouse will be offset. Specifically, the mouse stops on a menu, and the last menu is actually selected. Sometimes

PL/SQL Developer does not install a client to connect to a remote oracle database (for example, developeroracle)Labels ):Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html2. Download and install PLSQL (around 16 Mb ):Http://www.onlinedown.net/soft/4902.htm3. Unzip the instantclient-basic-win32-11.2.0.1.0.zip to a new folde

1. Configure the Oracle database connection In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database. Find the tnsnames. ora file under the Oracle Installation File. The general path is ORACLE_HOME % \ Network \ ADMIN: Orcl =(Description =(Address = (Protocol = TCP

Tags: RAC oracl SID Connection database permissions Forbidden Oracle user DDEWhen you create a new connectionConnection name: Your own casual name (but preferably the same as the project name)User name:Password:Host name: The IP address of the DB file namePort: The port in the DB file nameThe name after the port in the Sid;db fileSVN report URL Access forbidden for unknown reasonProbably because there is no SVN permission for the projectQuestions abou

The previous blog describes the method of backing up Oracle with the Navicat tool, which describes how to import and export an Oracle database using the PL/SQL developer tool.PL/SQL Developer is one of the primary tools used by

How to create a user using oracle SQL Developer, oracledeveloper This is for Oracle11g. I don't know if I haven't tested other versions. First, use system to establish a connection. The password is the password you specified during installation, and then create a new user in the "other users" at the bottom. Note 1: After creating a role, you must grant the DBA

Tags:httpcom use data html cti This you need to install a 32-bit Oracle client to use Plsql, but at this time sqlplus can not be used, hehe . I tried the following method, successfully, haha 1) install Oracle 11g 64-bit 2) Install the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0) :http://www.oracle.com/

Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"Add the following to the server address:10.88. 250.28 = = =10.88. 250.281521) ))) (= ORCL ) )) Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connected db instance, Port = 1521 is the Oracle Se

Label:Original: http://blog.csdn.net/kimsoft/article/details/8751267 Operating system: Windows 7 64-bit flagship requirements, install PL/SQL developer for development First, download the official Oracle Lite Green Edition Http://www.oracle.com/technetwork/topics/winsoft-085727.html Special note To download the 32-bit, because PL/