Tag:oracle
-
Time:2019-12-9
Rownum is a unique keyword in Oracle database. It returns a number representing the row number of the record. Basic knowledge: rownum can only query < or < = conditions. If rownum needs to judge the range from 51 to 100, it needs to first find out the rownum of each row, and then use […]
-
Time:2019-12-8
Oracle queries by day, week, month, quarter and year Day — to_char (t.start_time, ‘yyyy-mm-dd’) Week — to char (t.start time, ‘yyyy’), to char (t.start time, ‘IW’) Monthly -‘to’char (t.start’time, ‘yyyy-mm’) Quarter — to char (t.start’time, ‘yyyy’), to char (t.start’time, ‘Q’) Year -‘to’char (t.start’time, ‘yyyy’) Query by day select to_char(t.start_time,’YYYY-MM-DD’) day ,count(*) from test t Where […]
-
Time:2019-12-7
This article mainly introduces the example of win Oracle monitoring file configuration reference code. The example code is introduced in detail in this article, which has a certain reference learning value for your study or work. You can refer to the following for your friends Win lister.ora configuration reference # listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora […]
-
Time:2019-12-6
The two field values of Oracle database are comma separated strings, for example, the value of field a is “1,2,3,5”, and the value of field B is “2”. To get the intersection (same value) 2 of two fields, get the difference (difference value) 1,3,5 of two fields. I. the final SQL statement 1. Get intersection […]
-
Time:2019-12-5
Tonight, at 0 o’clock tonight, the premiere of Avengers 4 – the battle of the last! What’s the hardest to rob in April? It’s definitely a ticket pre-sale for the premiere of Avengers 4. It’s hard to stop the fans’ enthusiasm when the ticket price reaches nearly 300. I don’t know if you’ve got tickets. […]
-
Time:2019-12-4
In this paper, an example is given to show how Oracle can dynamically query data from 8:00 a.m. to 8:00 a.m. the day before. To share with you for your reference, as follows: You need to query the data from 8:00 a.m. to 8:00 a.m. of the day before Here is the query SQL statement […]
-
Time:2019-12-3
I. problem review At present, we have table a and table B, which have one column respectively. The results we want to query are shown in table C, which contains the columns of table a and table B at the same time; II. Solutions For the convenience of testing, we directly use the table emp […]
-
Time:2019-12-2
I. fault description The ASM disk group is offline. The ASM instance cannot be mounted. ASM disk group consists of four 500g disks. The database and ASM software are 10.2.0.1. It is urgent to restore Oracle database. II. Fault analysis Analyze the disks that make up the ASM disk group, take out the ASM metadata, […]
-
Time:2019-12-2
This article is one of the Oracle apex series articles of gangge. The complete Oracle apex series articles are as follows: Oracle apex series article 1: Oracle apex, let you change the black technology of full stack development in seconds Oracle apex series article 2: build your own apex complete development environment on Alibaba cloud […]
-
Time:2019-12-1
Query lock table select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o ,v$session s where l.object_id = o.object_id and l.session_id=s.sid ; Kill the watch(killing in the process) alter system kill session ‘543,9206’; If you can’t kill it, you can check this to get the SPID(give the obtained SPID to the authorized network administrator, and he will kill […]
-
Time:2019-11-30
This article is one of the Oracle apex series articles of gangge. The complete Oracle apex series articles are as follows: Oracle apex series article 1: Oracle apex, let you change the black technology of full stack development in seconds Oracle apex series article 2: build your own apex complete development environment on Alibaba cloud […]
-
Time:2019-11-29
This article is one of the Oracle apex series articles of gangge. The complete Oracle apex series articles are as follows: Oracle apex series article 1: Oracle apex, let you change the black technology of full stack development in seconds Oracle apex series article 2: build your own apex complete development environment on Alibaba cloud […]