PL/SQL Developer double-click table name query, pldeveloper
Double-click a table. The default value is Expand/Collapse. To Expand/Collapse a table, you need to view the table data quickly. If you write select * from tab, it will be troublesome,
Double-click table to perform quick query.
Method:Tools-> Preferences->
Query for a field with Chinese text
SELECT * from Issue I where ASCIISTR (i.id) like '%\% '
Query a field with English letters
SELECT * from Issue I where regexp_like (I.id, '. [A-z]+[A-z]) (red font changes randomly)
Renaming
In the SQL Script window, right-click on the table name to select ' Rename ', modify it in the popup window, tap ' OK '
WHERE mat_nameclt_name UPDATE distribution_mat SET distribution_mat.distribution_mat_count= Distribution_mat.distribution_mat_count +temp. Plusminus_count from (SELECT DM.*, t.plusminus_count from distribution_mat20150407 DM right JOIN (SELECT DISTRIBUTION_MASTER_ID,MAT_ID,MPMD. PLUSMINUS_COUNT,MPMD. PLUSMINUS_TYPE,MPMM. IsNew from Materialplusminus_master mpmm left joins Materialplusminus_details MPMD on MPMD. plusminus_master_id=MPMM. plusminus_mas
Double-click Table Defaults to Expand/collapse expand/collapse Sometimes you need to quickly view the table data, if writing select * from tab will appear troublesome,We can make a quick query by double-clicking the table.The method is:Double-click Action (Table), User Interface, Browser, Tools, Preferences, Quer Y Data)Reprint Please specify source: http://blog.csdn.net/itmyhome1990/article/details/38663783PL/SQL
Tags: select fill idt LAN row content query action GravityDouble-click the table default feel Expand/collapse expand/collapse sometimes need to view the data at a high speed, assuming that writing a select * from tab will appear troublesome,We can achieve high-speed query by double-clicking table.The method is:Double-click Action (Table), User Interface, Browser, Tools, Preferences, Quer Y Data)Reprint Plea
duplicated in category
Select COUNT (distinct name) from Category: Find out the number of name not duplicated in category
11. New statement: (Insert into)
Insert into book (bookname,bookprice,bookauthors) VALUES (' C # basics ', ' + ', ' Ji ')
(insert bookname,bookprice,bookauthors The values of the three fields are: ' C # basics ', ' ' x ', ' Ji ') 12. UPDATE statement: (
Label:Believe a lot of friends in Plsql Developer debugging Oracle , often encountered in Plsql developer execution of a certain SQL statement is not saved, then we in Plsql Developer how to find the SQL statements we executed, in fact, by the following methods are easy to a
the name that is not duplicated in category
Select COUNT (distinct name) from Category: Find out the number of name not duplicated in category
11. New statement: (Insert into)
Insert into book (bookname,bookprice,bookauthors) VALUES (' C # basics ', ' + ', ' Ji ')
(insert bookname,bookprice,bookauthors The values of the three fields are: ' C # basics ', ' ' x ', ' Ji ') 12. UPDATE statement: (
Label:a), First of all, let's say the error phenomenon: Most of the popular Ecshop templates on the market need to execute a paragraph or a few SQL statements to modify the data structure or initialize some of it. Most Ecshop administrators will execute these SQL statements through the Ecshop backend database management SQL q
Tags: Execute SQL query to modify update multiline recordTypically, we use the following SQL statement to update field values:UPDATE mytable SET myfield= ' value ' WHERE other_field= ' other_value '; UPDATE mytable SET myfield= '
category
11. New statement: (Insert into)
Insert into book (bookname,bookprice,bookauthors) VALUES (' C # basics ', ' + ', ' Ji ')
(insert bookname,bookprice,bookauthors The values of the three fields are: ' C # basics ', ' ' x ', ' Ji ')12. UPDATE statement: (Update...set ... [where])
Update book set bookprice=30 where Bookname= ' C
When you execute an SQL query and UPDATE multiple rows of records, we usually use the following SQL statement to UPDATE the field value: 1 UPDATE mytable SET myfield = 'value' WHERE other_field = 'other _ value'; however, if you w
Execute an SQL query and UPDATE multiple rows to record bitsCN.com
Execute an SQL query and UPDATE multiple rows of records
Generally, the following SQL statement is used to
Tags: Name table structure FETCH number SET COMM SQL statement SEL Date SelectFirst, query statements Get the first 10 records of data Oracle SELECT * from tab where rownum SQL Server: Select Top Ten * from tab Mysql: SELECT * from tab limit 10 SELECT * FROM table name limit m,n; Starting with M, take N bar Second, update
Copy codeThe Code is as follows: -- PK
Select * from sys. key_constraints where object_id = OBJECT_ID ('tb ')
-- FK
Select * from sys. foreign_keys where parent_object_id = OBJECT_ID ('tb ')
-- Create a linked server
Exec sp_addrole server 'itsv', '', 'sqloledb', 'remote server name or IP address'
Exec sp_add1_srvlogin 'itsv', 'false', null, 'username', 'Password'
-- Query exampleSelect * from ITSV. Database Name. dbo. Table Name
-- Import exampleSel
sql In addition to the associated query, you can also associate update deletion, and sometimes a SQL to take care of data migration, avoid writing stored procedures. The following is a list of the various cascading operations scenarios for SQL. Main Table: Department table-
product sales Top 10: Here also put top this keyword introduced. Order BY that field Desc is sorted in descending order by that field, ASC ascending row. Top to take the number of previous data SELECT TOP Ten SalesOrderID,sumas fromGroupby hassum >10000ORDERby DESC-- Sort Top 10 data by sales from high to bottom Predicates for DISTINCT and all: If the database has 100 identical data. All loads the same data 100 times. Distinct loads only one piece of data. The remaining 99 are discarded. T
One of the new functions provided by Drupal 7 is the ability to use the Query Builder and Query Objects Query Builder to construct Query Objects without the need to write original SQL statements in the code, one is to improve code readability, and the other is to be compatib
Label:1) SQL Where conditionSelect Id= "Find" parametertype= "user" resulttype= "user" >select Id,name, age,address from User_c where 1=12) Select 3) Removes the extra comma from the set last condition in update SQLMYBATIS_ Dynamic SQL query, update
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.