The preceding article has written a field control and table control implementation under a page: http://blog.csdn.net/haqer0825/article/details/6987393
Learn another way to do this today:
Using Af:switcher
Put two groups of formlayout in a
A stored procedure is a program block stored in a data dictionary that can be shared among different users and applications, and enables optimization and reuse of programs.
First, the creation and execution of stored procedures
1. Create stored
Article for reprint, and then can not find the original Bo address, sorry
To_week_by_year (to_date (' 2015-1-1 ', ' yyyy-mm-dd '))
CREATE OR REPLACE FUNCTION to_week_by_year (sdate in DATE) return number is result number; BEGINSELECTTo_char
Instance recovery mechanism
With the Redo,undo and incremental ckpt concepts, it helps to better understand instance recovery
When an instance crashes, the DB buffer in memory is inconsistent with the datafile on the disk.
Two issues to
An efficient way to remove duplicate data
Table demo is duplicate copy from Dba_objects, has about 880,000, does not repeat is 27323, no index
Method One: Delete from demo a where A.rowid <> (select Max (ROWID) from demo B
Prepare data:
drop table test Purge;CREATE TABLE Test (ID number,Code varchar (20),Name varchar (20));INSERT into test values (1, ' 201401 ', ' aaa ');INSERT into test values (2, ' 201402 ', ' BBB ');INSERT into test values (3, ' 201402 ', ' CCC
First of all want to say, in fact very simple
SELECT * FROM (SELECT * to teststudent ORDER BY id DESC) where rownum=1;
Look at the SQL statement above
Execute the parentheses inside the query out all the students, and in descending order, in
Start Mysql:service mysqld Start
(1) Login to the database as Oracle, command: su–oracle
(2) Enter Sqlplus console, command: Sqlplus/nolog
(3) With the system administrator login, command: Connect/as sysdba
(4) Start database, command: Startup
(5)
Oracle Analyze Table2008-09-23 13:25
Url:http://hi.baidu.com/jdsnhan/blog/item/36fe7e01790809087bec2c31.html
Let's take a brief note.
Today, helping colleagues guide the data, from the development environment to the test environment, found that a
Because of the general AIX system used in the production environment since contacting Oracle dependencies, there are no known concepts related to Hugepage under Aix. Recently dealt with a problem with SuSE Linux under Hugepage. The direction of the
1. What is a view
A view is a virtual table
views are based on existing tables , and the tables on which the views are built are called base tables .
A statement that provides data content to a view is a SELECT statement that can be
Ideas:Randomly sorts the values taken out first, and then randomly sorts the results of each fetchExamples are as follows:SELECT * FROM (select T.code fromtbizops_province t ORDER by Dbms_random. RANDOM ()) where rownum SELECT * FROM (select T.code
Sometimes we simplify the left JOIN or right join to implement multiple table queries
select id="getsubjectclassifynews" resultmap="Baseresultmapcheckadvice" parametertype=" Com.cnten.pbPreach.subjectclassify.model.SubjectClassify ">
Select
1, first find the operation record of the tableSELECT * from V$sqlarea a where a.sql_text like '%tb_acct_sysdate% ';2, find the sql_id corresponding to the UPDATE statement from the above recordSELECT * from V$sqltext A,v$sqlarea b where
Business Description: Grouped by T.truckid,t.riskcode, with fractions in each grouping, taking the record with the largest score in the group.Example: A1 B1 5 6A1 B1 5 3A1 B2 2 5A1 B2 2 1has been grouped by a-B but I need the first and third data,
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service