Questions tagged [PL/SQL] (35)

3
answers

The Internet platform testing technical skills Oracle PL/SQL?

Need a platform with which you can test the technical skills of the candidate on knowledge of Oracle PL/SQL. It is desirable that the resource was Russian.
Jennie asked April 19th 20 at 11:52
0
answer

How to insert/update the values in the table with values from another table, provided that the total field is equal?

Good afternoon, prompt please in my problem. There is a table REPORT , which consists of columns MAC_ADDRESS, CREATED_DATE, HASH And a table COMPUTER, which from MAC_ADDRESS (as it is used to communicate with the REPORT), CREATED_DATE, CHANGED_DATE, HASH Initially, the COMPUTER table is empty, and REPORT periodically fille...
cary asked April 8th 20 at 01:54
0
answer

How to prepare for the certification exams Orcle 1Z0-144?

Exam 1z0-071 has been successfully passed, decided to start podgotovku for the exam 1z0-144 as I understand it goes next and to it requires a certificate 1z0-071. Looking for recommendations for books similar books as I was to 1z0-071 Steve O hearn I have not found. There is such a book https://habr.com/ru/company/piter/blo...
adolph_Crist asked April 7th 20 at 09:23
1
answer

How is it possible in one query to convert a string with date in different formats into one date field?

Good day, there is a column of type text in which the date values. Need to convert text to date format But the problem is that the date format is available in several versions, namely: FIELD mm/dd/yyyy yyyy-mm-dd dd.mm.yyyy I.e. the same format of questions no SELECT TO_DATE(field, 'mm/dd/yyyy') FROM table But what abo...
Katarina7 asked April 7th 20 at 08:55
2
answers

How to list the values using LISTAGG in a query with many JOIN from different tables?

Good day, have a table that will connect to many other tables via MANY-TO-MANY. The goal is to display the first field of the first table and values of the binding tables, but each in his field through the separator, i.e. as if denormalize information Here you can clearly see the problem sqlfiddle.com/#!4/9b70c/2 The result...
fiona62 asked April 4th 20 at 13:20
1
answer

How to add numbering in groups of similar records in SQL query?

Good day, there is a table that describes the characteristics of similar devices but with small differences in the properties table consists of the following: ID; DEVICE; FIELD; VALUE 1 ; the Monitor Model; LG 2 ; the Monitor; the Serial number; 12345 3 ; Monitor; date of issue; 01.01.2020 4 ; the Monitor Model; LG 5 ; Moni...
thea88 asked April 4th 20 at 12:57
2
answers

Is it possible to transpirirovat this table from rows to columns?

Good day, there is a non-trivial task transportirovke in PLSQL table from this state in this ie it turns out the table how to convert to a table like a directory, i.e. see what is described as if 2 monitors, but absent as such a sign dividing the data into 2 monitors, they only have 2 fields (serial number and date of issue...
Shaina_Ho asked April 4th 20 at 12:41
2
answers

How to normalize the table in the manual?

Good afternoon, prompt please how it is correct to normalize the table in the table type the directory where you have a table of the following kind: REPORT_ID ; IPAGE ; IFIELD ; IVALUE 1 ; Video Windows ; device Description ; IntelHD 2000 1 ; Windows Video ; video Type CPU ; Intel Family 1 ; Windows Video ; video memory ; 1...
nat.Legr asked April 4th 20 at 00:19
0
answer

How to create a procedure of loading data into Oracle?

There are 2 laboratory databases. OLAP No. 3-4 The challenge 1.Stvorennya procedures navantazhennya difference Butt vikonannya the challenge. 1) Independent pay not less then 3 jerel vakrita difference. For example - Registration administrativno-territorial arrange https://data.gov.ua/dataset/a2d6c060-e7e6-4471-ac6... Dome...
Saul.Bernier asked April 3rd 20 at 18:09
1
answer

Why in oracle pl/sql trigger does not respond to all rows that I insert into the table?

Hello! I have Oracle PL/SQL there is a table: This is a table of shots. I have people who are involved in the competition for accuracy in shooting. The column name describes the name of the shooter, column x shows the coordinate of the point of contact of the bullet x and column y shows the coordinate of the point being hi...
Herta_Hoeger asked April 3rd 20 at 17:35