Questions tagged [PL/SQL] (35)

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...