Because I got a Q A program of my own in the past two days, I found that the developer encrypted my stored procedure, depressed, and found a solution. now share: Open the query analyzer, go to your database and run the following SQL statement: CREATEPROCEDUREsp_decrypt (@ objectNamevarchar (50) ASbeginbegintra
Because I got a Q A program of my own in the past two days, I found that the developer encrypted my stored procedure, depressed, and found a solution. now share: Open the query analyzer,
Stored Procedure | decryption
Content from the Internet, the author unknown
drop procedure Sp_decrypt
Go
Create PROCEDURE Sp_decrypt (@objectName varchar (50))
As
Begin
BEGIN TRANSACTION--add by Playyuer
DECLARE @objectname1 varchar (100)
declare @sql1 nvarchar (4000), @sql2 nvarchar (4000), @sql3 nvarchar (4000), @sql4 nvarchar (
--Start
Speaking of Oracle analysis functions, it can be described in a very good and powerful sense. This feature is especially useful for a variety of statistical queries that are difficult to implement in normal SQL or are not implemented at all. First, let's start with a simple example, step by step to uncover its mystery, look at the following sql:
CREATE TABLE employ
(
name VARCHAR2)-- name
DEPT VARCHAR2 (a)-- Department
SALARY number -wages
);
INSERT into em
Create the following stored procedureThen callExec sp_decrypt @ objectName(@ ObjectName is the name of the encrypted stored procedure)Exposed!This program does not destroy the original stored procedure!Haha, it's fun!Create PROCEDURE sp_decrypt (@ objectName varchar (50 ))ASBeginBegin transaction -- add by playyuerDeclare @ objectname1 varchar (100)Declare @ sql1 nvarchar (4000), @ sql2 nvarchar (4000),
Gc log parameter migration in Java 9 and java9gclog migrationCollation
This article mainly studies the migration of gc log parameters in Java 9.
Unified JVM and GC Logging
Java 9 introduces a unified log framework to include gc-related log output and configuration.
JEP (JDK Enhancement Proposal)
JEP 158: uniied JVM Logging
JEP 264: Platform Logging API and Service
JEP 271: uniied GC Logging
Xlog syntax
-Xlog[:option] option := [
What
It mainly configures the tag and level.
Tag
All
90 INSTR ('Mississippi ',' I ', 3, 3)
91
9211
93
94 select INSTR ('Mississippi ',' I ',-2, 3) from dual
95
96 INSTR ('Mississippi ',' I ', 3, 3)
97
982
99
100
101 10000b (, [, I [, j])
102 is the same as the INSTR () function, but it only returns bytes. For a single byte, bytes B () is equal to INSTR ()
103
104 LENGTH ()
105 c1 is a string and the length of c1 is returned. If c1 is null, null is returned.
106
107 select LENGTH ('ipso facto') ergo fro
()
LENGTH ()
C1 is a string that returns the length of the C1 and, if C1 is null, returns a null value.
Select LENGTH (' Ipso Facto ') ergo from dual
Ergo
10
LENGTHB ()
Returns the byte, as in length ().
Lower ()
Returns lowercase characters for C, which often appear in the Where substring
Select LOWER (colorname) from Itemdetail WHERE LOWER (colorname) like '%white% '
ColorName
Winterwhite
Lpad (
. Select INSTR (' Mississippi ', ' I ', 3,3) from dual; INSTR (' Mississippi ', ' I ', 3, 3) 11 Select INSTR (' Mississippi ', ' I ', -2,3) from dual; INSTR (' Mississippi ', ' I ', 3, 3) 2 INSTRB (, [, I[,j]) As with the InStr () function, it is just that he returns a byte, for a single byte InStrB () equals InStr () LENGTH () C1 is a string that returns the length of the C1, and if C1 is NULL, a null value is returned. Select LENGTH (' Ipso facto ') ergo
start position of the key and POS2 indicates the end position of the key. -N: sort by numerical values. The empty string "" or "\ 0" is treated as null. This option does not recognize all non-numeric characters except. : When the key is sorted by numeric values and encounters unrecognized characters, the sorting of the key is immediately ended. -M: sort by month in string format. It is automatically converted to uppercase and take the abbreviated value. Rule: unknown
1.2 sort example
This sect
Sony (Japan) 10 thousand/month, only for graduate students China headquarters of South Korea's Samsung Electronics 0.25 million/year French Somm software, with an annual salary of 0.2 million RMB/year, working in Europe Cisco (Cisco) 15000/month, only for graduate students Intel 13000/month IBM 5000/month Siemens Germany 8000/month Tibet Unicom's 1 million year (must be 8 years old), but the altitude sickness is too hard. The monthly salary of Qinghai Unicom is 5000-7000, and you can on
/* -- The method for resolving strings that cannot exceed 8000
It is often mentioned that when data is processed using the dynamic generation of SQL statements, the processing statements are too long and cannot be processed.This issue is discussed below:-- Producer build 2003.9 (reference please keep this information )--*/
/* -- Test environment
-- The system table syscolumns is used as the test data, and the xtype column and name column are used as the row fields to calculate the sum of colid a
To save table space, plan to migrate part of the table to another library, because no previous implementation of the similar, migrated up the script to make a West one, audit did not make it in place, resulting in some of the data is unsuccessful, but also repeated verification, or data is not much, 720 tables.
1 build table, index, host script mainly
2 After you run the build script, import the data in non-archive mode and change to archive mode
3 Audit data lines before and after the consisten
Error logs recorded during DML Process
When you insert millions of data records, the insertion fails due to several dirty data records. Oracle 10g R2 has a new feature that inserts records that failed to be inserted into another table.
SQL> drop table test purge;
SQL> drop table test_bad purge;SQL> create table test as select * from dba_objects where 1
SQL> execute dbms_errlog.create_error_log ('test', 'test _ bad ');
Create table TEST(OWNER VARCHAR2 (30 ),OBJECT_NAME VARCHAR2 (128 ),SUBOBJECT_
$ varchar2 (2000) oracle error message textOra_err_rowid $ rowid Of The Wrong row (for update and delete)Ora_err_optyp $ varchar2 (2) Operation Type: insert (I), update (u), delete (d)Note: errors in the update and insert clauses of merge operationsDistinguish between U and IOra_err_tag $ varchar2 (2000) label value provided to the error logging clauseBytes --------------------------------------------------------------------------------------------------------------Table: column data type of th
1. Start to restore the original paging stored procedure.
Copy codeThe Code is as follows: alter procedure [dbo]. [sp_ SQL _Paging]
(
@ SqlDataTable NVARCHAR (4000), -- table name
@ PrimaryKey NVARCHAR (4000), -- primary key name
@ Fields NVARCHAR (4000), -- the field to be returned
@ PageSize INT, -- page size
@ PageIndex INT, -- page number
@ RecordCount int ou
Php
5000~7000
2000~6000
8000~9000
4000~8500
5000~7000
How are these random sets of data in PHP more effective in judging if there are duplicates?
Expectations are
2000~4000
4000~5000
5000~6000
6000~7000
7000~8500
8500~9000
Reply to discussion (solution)
This post was last edited by xuzuning on 2013-10-09 09:00:13
$a = Array (array (7000), array (6000
1. Start the restore below first look at the original paging stored procedures.
Copy Code code as follows:
ALTER PROCEDURE [dbo]. [Sp_sql_paging]
(
@SqlDataTable NVARCHAR (4000),--table name
@PrimaryKey NVARCHAR (4000),--primary Key name
@Fields NVARCHAR (4000),--the field to be returned
@pageSize INT,--page size
@pageIndex INT,--page number
@
TABLE Tb_orderinfo(Oid_billno VARCHAR (32),order_id VARCHAR (+) NOT NULL,OID_CHNL VARCHAR (2) NOT NULL,TYPE_DC VARCHAR (1) NOT NULL,Oid_reguser VARCHAR (+) NOT NULL,Dt_sys DATE,Trans_date CHAR (8) NOT NULL);-----------------Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. Some columns to TEXT or BLOBsCREATE TABLE IF not EXISTS ' dbpay '. ' Sys_export_schema_01 ' (' Process_order ' BIGINT,' DUPLICATE
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.