connect to oracle database from excel macro

Sometimes when you connect to the database, you will find that the database cannot be instantiated. When you start Tomcat, you may see the following error message: Listener refused the connection with the following error: ORA-12514, TNS: Listener does not currently know of Service requested in connect ...... This is

reflecting common Driver objects. Driver Driver = (Driver) class.forname (Driverclass). newinstance (); Properties Info = new properties (), Info.put ("user", user), Info.put ("PassWord ", password);//Get a database connection through the Driver connect method. Connection Connection = Driver.connect (Jdbcurl, info); return Connection;} @Testpublic void Testgetconnection () throws Exception{system.out.print

Package com. xuankai. JDBC; Import java. Io. fileinputstream;Import java. Io. ioexception;Import java. SQL. connection;Import java. SQL. drivermanager;Import java. SQL. resultset;Import java. SQL. sqlexception;Import java. SQL. statement;Import java. util. properties;Import java. SQL .*; Public class sqlhelper{// Define variablesPrivate Static connection Ct = NULL;// Replace statement with preparedstatement in most casesPrivate Static preparedstatement PS = NULL;Private Static resultset rs = NUL

Transfer from http://www.jiejingwang.com 2002-10-24 shortcut Network========================================================== =System Environment:1. Operating System: Windows 2000 Server, 128 MB of machine memory2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition3. installation path: C: OracleSteps:1. Open Microsoft Excel 20002. File (f) → new (n) → work

Source: Https://zhidao.baidu.com/question/383828330.html?qbl=relate_question_2word=excel%20%B1%ED%CA%FD%BE%DD %d4%f5%c3%b4%d0%b4%c8%eborancleThe procedure is as follows: Prepare your data: Build the data you need in Excel 2. Save the data in Excel as a text file (Tab delimited)3. Import data from a newly saved to a text file into Pl*sqlSelect Tools-

Main Implementation ideas:1. Declare a record to store exported data;2. Use a cursor to retrieve data to the record;3. Use utl_file to write the recorded data into an excel file;4. Perform steps 2 and 3 cyclically to export data.Main problems encountered during the process:1. How to write data to the next column in The excle file;The TAB character is used to complete the horizontal hop in excel. The TAB cha

Insert data into the database (ORACLE) through excel We all know that PL/SQL can copy data to excel, and we can also insert data to the database through excel. The following is a simple example and example. First, create a tabl

Tags: style blog http ar for data SP logWe all know that PL/SQL can copy data to Excel, and we can also insert data into the database via Excel.Let's take a simple example with a demoFirst, we create a table testCREATE TABLE Test (ID number);Then we execute the following statementSELECT * from test for UPDATE;and open the lock.Then we copy a column of numeric data in Excel.Select the column name id,ctrl+v i

1. Right-click and choose create> Microsoft Excel.2. Add data (corresponding to column names and data)3,File (f) → save as (a) →The storage type is as follows: delimiter, and the name starts from text.txt (the name is casual, but it must be a TXT type). Save it to D :\ 4,Connect to SQL * Plus (this step is omitted if the table has been created in the database)L

Export data to an Excel file: select the data table -- query data -- select the data to be exported -- Right-click Copy to excel to import data to the database: 1. Prepare the data to be imported in Excel. Specific Operation: In Excel, set the first column as an empty column

ODBC imported and text imported in 1.plsql, you can select file import directly. Specific import operation details are not detailed. Large data volume import efficiency is not good;2.sql develop, select the target table, select "Import data" from the right-click menu, save the Excel file in CVS format, browse to select, and follow the wizard. The efficiency is relatively high!380,000 data about 14 minutes to complete the import.Several ways to import

1, the use of tools Plsqldev 2. Open the Excel table you want to import, click the Office Button, choose Save As--other formats, select Save Type CSV (comma-delimited) (*.csv), click Save 3, open Plsqldev in the toolbar Select the Tools Drop-down menu under the text importer. Select the data from Textfile tab after entering. Click the following button with a red line box to open the CSV file.If the success is turned on, select the "Data to

for the connectionprivate static String url= "Jdbc:oracle:thin: @localhost: 1521:ORCL";System is the user name for logging into Oracle databaseprivate static String user= "System";Manager is the password for user name Systemprivate static String password= "manager";public static Connection Conn;public static PreparedStatement PS;public static ResultSet RS;public static Statement St;Ways to connect to a dat

soon as the user process terminates. In addition, we also have a connection method, called a shared connection. In the case of a shared connection, the DBA can define the number of server processes. When the database is started, Oracle establishes the specified number of server processes in the instance in advance. At this point, the user process no longer has a one-to-one relationship with the server pro

excel|oracle| Data | Database system environment: 1, operating system: Windows Server, machine memory 128M 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, Installation path: C:\ORACLE Implementation steps: 1, open M

click on the number of buttons: Start debugger or press F9;3), Last click: RUN or Ctrl+r.debugging shortcut keysToggle Breakpoint: Ctrl+bStart: F9Run: Ctrl+rSingle Step Into: Ctrl + NStep Skip: Ctrl+oSingle Step exit: Ctrl+tRun to Exception: Ctrl+y8. Template shortcut keys9. My Objects is automatically selected by default after loginBy default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you will need to wait a few seconds for the table

Tnsnames.ora file can also be copied from the Network\admin directory of the Oracle database home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname) 3. Configuring the Oracle Home and OCI libaray for PL/SQL developerEnter the PL/SQL Devel

= (SERVER = dedicated) (service_name = ORCL) ) ) You can add your own configuration at the end of the Tnsnames.ora fileXXXXX = (DESCRIPTION = ( ADDRESS = (PROTOCOL = TCP) (HOST =xxxxx) (PORT = 1521)) (Connect_data = (SID = ORCL) (SERVER = dedicated) ) )Here is a misunderstanding is if your connection name (that is the first line above the xxxxx), the front can not have any characters, space is not.Otherwise PL/SQL developer Log on: Ora-12154:tns: Unabl

of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and

example, my machine is: d:/instantclient_11_2/network/admin4. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and co