Questions tagged [Oracle] (487)

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.

Hello! There are two tables: Need to get a list of sellers and the number of orders that have the maximum number of goods sold. T-sql implements the query: select top(1) with ties s.Name , sum(isnull(o.Amount, 0)) as Quantity from Sellers as s inner join Orders as o on s.id = o.Salesperson_id where o.Order_date is ...

I go under system writes is ora-28002 some gibberish 7, how to change a password to was eternal?

Good day, Faced with such a situation: a bunch of articles on how to using python to connect to Oracle (cx_Oracle) to get data from a DB and then how to add back to the database data — the answer is not found. All the calculations I gather in the format of pd.DataFrame Please help if anyone solved a similar problem or hav...

How to replace characters large small and small large using Regex ORACLE. This should be done for any string.

Oracle 11. There is a need to represent relational structure as a graph. Can this Oracle and what side effects it may have? I suspect that speed. Much slowly?

Is it possible to somehow simplify the following query? To ensure that the sample was not re -: WHERE main_person.inn IN -- where the head is the founder ( select grf.inn -- founders from mytablename t LEFT JOIN FOUNDERS grf ON grf.record_id = t.grn_record_id LEFT JOIN MAIN_PERSONS ON grmp grmp.record_id = t.grn...

I need to get the first 10 records. Online for Oracle 11 propose to do so: SELECT * FROM ( select name from ... ) WHERE rownum < 10 ie on request. I understand that it is not effective because in the beginning it will be the whole subquery, and then it will be filtered? Or how are things going?

A select that pulls out a record based on maximum value of the 1st field SELECT * FROM ( SELECT discount, osp_id, sero_id, estpt_id, ROW_NUMBER() OVER (PARTITION BY osp_id, sero_id, estpt_id festpae_id ORDER BY DESC) as festpae_id FROM database1 data1 JOIN database2 data2 ON data2.id = data1.attr_id WHERE data1.in...

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