concatenate in oracle sql query

Query all the elements of a distance from a certain point (that is, the surrounding query) SQL: Select T. objectid, T. comp_type, T. datatype, T. comp_name, T. health_lic, T. shape. sdo_point.x as x, t. shape. sdo_point.y as Y, T. reg_addr, T. bus_addr from t_publicplaces t where 1 = 1 and substr (T. comp_type,) = '01' and sdo_within_distance (T. shape, sdo_geom

SQL connection query for Oracle databasesPrefaceIn reality, there is such a requirement that sometimes the data we need to query is in multiple tables, so how to query data from multiple tablesWhat about it? In this case, you need to use table connections to perform queries.

"> 2. Merge into statement: For the top statement, you can use the merge into statement --Merge into implementation method merge into EMP using (SELECT * from emp_new1 ) E on (e.empno = emp.empno) when matched then update set emp.empdesc = E.empdesc;The execution results are the same as the results in 1, assuming inference. It is recommended to use the merge into method. Because merge into only visits once emp_new1. Iii. Deleting delete op

Oracle Query result set, random sort Copy Code code as follows: SELECT * FROM table1 ORDER by Dbms_random.value (); MySQL randomly query out a record: Copy Code code as follows: --The following query statement is efficient, do not use SELECT * FROM table1 to rand () LIMIT to

☆Retrieve all table names and column names of the databaseSelect name from sysobjects where xtype = 'U'Select name from syscolumns where id = (select max (id) from sysobjects where xtype = 'U' and name = 'table name ')☆Recursive Data QueryRecursive query of SqlServer2005 and Oracle in SQL statementsI used Oracle before

One of the Oracle-SQL skills (query continuous records) Requirement Description: www.2cto.com needs to query that a customer has been continuously performing business for those days of a year. The SQL implementation is as follows: Create a table: create table test_num (tyear

include non-conforming data in the right table in addition to the data in the inner join, enter the null value in the corresponding column of the Left table.The SQL statement is as follows:Select * from mt_pb_org o right join mt_pb_orgframe on o. pb_orgframeid = f. pb_orgframeid;Equivalent statement:Select * from mt_pb_org o, mt_pb_orgframe f where o. pb_orgframeid (+) = f. pb_orgframeid;3. full outer join (full [outer] join)A full outer join is to

Different databases: oracle mysql SQL Server DB2 infomix sybase paging query statement, infomixsybase Paging query statements used in different databases: Current page: currentpagePage size: pagesize 1. Oracle Database Select * from (select A. *, rownum rn from (QUERY_

BackgroundWhen using Oracle or other databases, using the LIKE keyword for fuzzy query is commonly used by people, in the use of pure Chinese environment is very easy to use, there are some wildcards can be used, but in a pure English environment, the size of the need to accurately match the problem, the main reason is the problem of string FL like '%{0}% ' and Here like after is a string, so

ORACLE basic SQL statements-query, oraclesql statements 1. Common Query /* Query table data */Select * from STU /* Retrieve the first three rows of Data */Select * from stu where ROWNUM /* Fuzzy query */Select * from stu where s

My SQL is very poor, half a day response to, was a colleague joke. Oh, ah ah. Must surpass him later!!Table ShopPk_shop PRIMARY KeyName Commodity Shop Pk_shop Name 001 Down 002 Coca - cola Bpm_ll_test2 PK_BPM_LL_TEST2 PRIMARY Key Sname Product Name 01 001 Select (select name from shop where shop s s.pk_shp

Copy codeThe Code is as follows:-- Oracle reads SQL statements from last Monday to weekend-- The day of the week starts on Sunday.Select to_char (to_date ('201312', 'yyyymmdd'), 'D') from dual;-- Result: Note 6: the sixth day of the week is Friday.Select to_char (sysdate + (2-to_char (sysdate, 'D')-7, 'yyyymmdd') from dual; --- last MondaySelect to_char (sysdate + (2-to_char (sysdate, 'D')-1, 'yyyymmdd') fr