sqlcode

Create or replace procedure t_ps_trycalculate (v_date in varchar2) As /* The monthly performance check determines whether the employee's performance is successful based on parameters. Parameter: v_date performance year/month */ -- Define error Variables Some_kinds_of_err exception; -- Exception to indicate an error condition V_errorcode number; -- variable to hold the error message code V_errortext varchar2 (2000); -- variable to hold the error message text V_error_ SQL varchar2 (4000); -- SQL s

: -- ========================================================== ==================== Select * Into Newtable From OpenDataSource ( ' Microsoft. Jet. oledb.4.0 ' , ' Data Source = "C: \ book1.xls"; user id = admin; Password =; extended properties = Excel 5.0 ' )... [ Sheet1 $ ] Instance: Select * Into Newtable From OpenDataSource ( ' Microsoft. Jet. oledb.4.0 ' , ' Data Source = "C: \ finance \ account.xls"; user id = admin; Password =; extended p

, 'taobao', 16, 'wan', null)Into v_upperpart from dual;V_upperstr: = v_upperpart | v_upperstr;End loop; V_upperstr: = Replace (v_upperstr, 'zero restart', 'zero ');V_upperstr: = Replace (v_upperstr, 'zero failed', '0 ');V_upperstr: = Replace (v_upperstr, 'zero failed', '0 ');V_upperstr: = Replace (v_upperstr, 'zero zero 0', 'zero ');V_upperstr: = Replace (v_upperstr, '0', '0 ');V_upperstr: = Replace (v_upperstr, 'zero-angle and zero-point', 'Integral ');V_upperstr: = Replace (v_upperstr, 'zero p

. servername = "CWD"Sqlca. logid = "sa"Sqlca. autocommit = falseSqlca. dbparm = ""// The following is generally not usedSqlca. userid = ""Sqlca. dbpass = ""Sqlca. Lock = ""Connect using sqlca; Sqlca. sqlcode = 0 // database connection successful-1 // database connection Error100 // The connection is successful, but no data is retrieved (usually used in DW) ◆ Close ()This event is triggered when the user closes the application. This event has no parame

the table, other programs can also obtain the IX lock of the table for data modification. However, after the lock is upgraded, the program will upgrade the table to the S lock, other programs cannot modify the table. Will be in the lockwaiting status.The lock upgrade may fail. It is easy to understand. Next, the above lock is originally is, And the IX lock is not released yet. The lock is upgraded to the S lock, but s and IX are not compatible, in this case, the lock upgrade fails. The applicat

---- Start Stored Procedures can call each other. How can we transmit data between them? There are three methods. I. Data Transmission Through Input and Output Parameters This is the simplest method, but it is worth noting that the return statement in the stored procedure has different meanings than the return statement in other programming languages. The Return Statement in the stored procedure puts back the sqlcode value. Ii. pass data through sessi

(sysdate, to_date (substr (min (partition_name), 7,8), 'yyyy-mm') into v_over_time From user_tab_partitions where table_name = 'sale _ data '; -- Delete the earliest Partition If v_over_time> 12 then Execute immediate 'alter table sale_datadrop partition '| v_part_name; End if; Exception When others then V_err_num: = sqlcode; V_err_msg: = substr (sqlerrm, 1,100 ); Dbms_output.put_line ('execution error: '| v_err_num |' error Description: '| v_err_ms

and Oracle need to specify this parameter. 7 Logpass String The user password used to log on to the database server. This attribute can be set but cannot be set, but Sybase and Oracle need to specify a password. 8 Servername String Database Server name. 9 Autocommit Boolean Specifies whether to set the database to automatically submit all transactions. The default value is false. That is to say, you must manage transactions in the applicatio

of the messages? You can do that with the following two commands in a pre-extract stored procedure.Set message = offset emgsrv = OFFBut a warning: some error messages are also disabled, so if there are problems with the flow, you may need to remove these settings to diagnose them. Rejected row messages. when the "key matching logic" option "include duplicates" is used with a relational database target, duplicate rows still can't be inserted into a table if there is a unique constraint. instead

Procedure feathures:Parameter modes:3 types of parameters: 1) in: Incoming data to Stored Procedure 2) Out: stored procedure returns data 3) inout: the part of the incoming data, overwritten by returned data during execution Result sets:Stored Procedure uses cursor to pass the result set to the caller. The stored procedure must retain a cursor for each result set to be returned.> Use with return to caller/client to specify the objects returned by the result set. If this parameter is set to clie

, oprnm, brhid, passwd from btpoper"4. Delete table data:Db2 "delete from btpoper"Db2 "delete from btpoper where brhid = '000000' or brhid = '000000 '"5. Modify Table data:Db2 "update svmmst set prtlines = 0 where brhid = '000000' and jobtp = '02 '"Db2 "update svmmst set prtlines = 0 where jobtp = '02 'or jobtp = '03 '"6. Database ConnectionDb2 connect to btpdbs7. Clear database connectionsDb2 connect reset disconnects the databaseDb2 terminate disconnect DatabaseDb2 force applications all disco

are created in SQL.PB cannot dynamically create SQL triggers with variables? Messagebox ("", ls_mysql)// After the prompt box is displayed, press ctrl + c to copy the prompt box content, and then press ctrl + v to query the analyzer to see if there is any problem.Sqlto. autocommit = trueExecute Immediate: ls_ SQL; If sqlto. sqlcode = 0 ThenMessagebox ("", "successful! ")ElseMessagebox ("", "failed! "+ Sqlto. sqlerrtext)End IfSqlto. autocommit = false

user to execute "db2stop" 2) modify the server host name (for details about how to modify the host name in various operating systems, refer to the relevant operating system documentation) 3) Run db2set-gDB2SYSTEM=db2terminate The above command should not cause any problems on Windows. However, if your operating system is Linux or UNIX, errors may occur at this time, for example, V8 or V9.1, You will encounter the following error message: $db2set–gDB2SYSTEM=pirates DB2SETprocessin

rollback is expected to be completed within 5.04 hours. Note: in other environments, replace KTUXEUSN with KTUXESLT = 5. SQL statements for Oracle-defined transactions SQL> select * from test_main; ID VALUE------------------------------2 TWO3 THREE1 ONESQL> BEGIN2 -- insert two identical data records to repeat the primary key and roll back the transaction after an error is thrown.3 insert into test_main (id, value) VALUES (4, 'four ');4 insert into test_main (id, value) VALUES (4, 'four ');5 CO

, Oracle_error_code number );Rem Create the new empty table:Create table new_tableAs select *From affected_tableWhere 1 = 2;Set serveroutput onDeclareN number: = 0;Bad_rows number: = 0;Error_code number;Ora600 EXCEPTION;PRAGMA EXCEPTION_INIT (ora600,-600 );BeginFor I in (select rowid rid from affected_table) loopBeginInsert into new_tableSelect *From affected_tableWhere rowid = I. rid;N: = n + 1;ExceptionWhen ora600 thenBad_rows: = bad_rows + 1;Insert into bad_rows values (I. rid, 600 );Com

Connection character: |Value assignment: ": ="For example, l_name: = 'sky ';Determine whether the values are equal: "="For example, if 1 = 1 then...Variable binding :":"For example, if: P_NAME = 'sky' then... ExistsNot exists does not exist % Type matching Field type% Rowtype matching record type% Type when the table type changes, you do not need to manually modify the type called in PL/SQL blocks.Example: V_GP_ID SC _BALANCE_DAILY.Gp_Id % TYPE; Sqlcode