sql developer training

At the end of the year, the main write Java has been more than half a year. During this half-year period, I learned to use Spring-boot, learned SQL, and learned to use MongoDB. At first glance, the content of my work seems to be mostly "back-end", so can I calculate a half back-end development? I don't think so.Yes, I started working on Java and databases in the last six months, but my job is essentially "data presentation" to the front page. Just bef

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) (host = localhost) (Port = 1521 ))(CONNECT_DATA =(Server = dedicated)(SERVICE_NAME = orc

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 you cannot open the menu by clicking the mouse. You need to press and hold the mouse to o

After Oracle is installed, the first thing to do is to think about how to connect and proceed. SQL Developer is a powerful tool officially provided. In my opinion, it is also the first choice. The latest version on the official website is 4.0.1.14.48. After downloading it, you are eager to try it out. Run the downloaded package and run the sqlcmd.exe file directly. After selecting the JDK path installed loc

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 folder, such as D:/oracleclient/instantclient_11_2

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 permission to the newly created user on the

Label:This is for oracle11g, other versions of the test has not been known.First, use system to establish a connection, the password is the one you specified when you installed it, and then create a new user in the bottom "other user".Note 1: Be sure to give DBA authority to the newly created user in the Roles tab, otherwise you will not be able to log in.Note 2: Also check the system tablespace in the "Quota" tab, otherwise the table will be created with no permissions to create the table in Sy

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 about connecting to a database with Oracle

There are two ways to find it online:1. Through Configuration and migration ToolsNet manager→ local → profile →oracle Advanced Security → validation → Remove the "NTS" in the selected method, the key is to not restart the database.2. Locate the installation directory: App/product/10.2.0/dbhome_1/network/admin Open Sqlnet.oraFind Sqlnet in there. Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out: #SQLNET. Authentication_services= (NTS). This met

client directory, create a new folder network, the network in the new admin, in the admin directory, a suffix named. ora file: Tnsnames.ora\instantclient_11_2\network\admin\tnsnames.oraNotepad opens and the content is added as follows:# Tnsnames.ora Network Configuration File:d:\oracle\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)))(Connect_data =(service_name = ORCL)))Test-name

Tags: select fill idt LAN row content query action GravityDouble-click the table default feel Expand/collapse expand/collapse sometimes need to view the data at a high speed, assuming that writing a select * from tab will appear troublesome,We can achieve high-speed query by double-clicking table.The method is:Double-click Action (Table), User Interface, Browser, Tools, Preferences, Quer Y Data)Reprint Please specify source: http://blog.csdn.net/itmyhome1990/article/details/38663783PL/

database. After filling out the next step directly.(6) Enter this page, you can click the Test button to test the database connection. (7) The user name and password of the current login, the result of the test and the reason are displayed after entering. After entering, click the Change Login button to modify the user name and password. The user name starts with the LC , the middle is the instance name (m572)in the GS Suite, and finally the 9999. The password is the password that is connected

=650; "src=" Http://s3.51cto.com/wyfs02/M02/76/A3/wKiom1ZYEkzQ0S6hAAC0mppqcpU848.png "style=" float: none; "title=" QQ picture 20151127161554.png "alt=" Wkiom1zyekzq0s6haac0mppqcpu848.png "/>650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/76/A3/wKiom1ZYEk2TxuOGAACuamQQdIc156.png "style=" float: none; "title=" QQ picture 20151127161617.png "alt=" Wkiom1zyek2txuogaacuamqqdic156.png "/>650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/76/A3/wKiom1ZYEk7g_hWrAACr_nKZcxY607.png "st

Tags: SQL query statement SQL statement SQL Tutorial SQL language SQL database tutorialOracle SQL Language Foundation and Environment readiness-beyond OCP proficient Oracle Video Tutorial Trai