Questions tagged [Oracle] (487)

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
1
answer

How to convert query from t-sql to oracle sql?

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 ...
Ana_Ba asked April 18th 20 at 13:07
1
answer

How to change the password in the database?

I go under system writes is ora-28002 some gibberish 7, how to change a password to was eternal?
aliza.Champlin asked April 9th 20 at 10:30
1
answer

How to download the results of calculations from Python to Oracle?

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...
joanie.Johnson asked April 8th 20 at 18:01
1
answer

How to replace characters large small and small large using ORACLE Regex?

How to replace characters large small and small large using Regex ORACLE. This should be done for any string.
Favian_Renne asked April 7th 20 at 11:07
0
answer

How Oracle fits for graph data?

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?
Raleigh_Colli asked April 7th 20 at 11:06
2
answers

How to simplify the following query?

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...
deborah_Medhurst35 asked April 7th 20 at 10:32
1
answer

How to organize a proper LIMIT in Oracle?

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?
Jaydon asked April 7th 20 at 09:53
1
answer

Oracle. How to return the correct record based on field values?

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...
kayden.Kirlin asked April 7th 20 at 09:27
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