Closed 14 mins ago.

PRODUCT_ID PRODUCT_NAME PRICE 1 S8 1000 2 G4 800 3 IPHONE 1400 SELLER_ID PRODUCT_ID BUYER_ID SALE_DATE QUANTITY PRICE 3 3 3 14-05-19 2 2000 1 1 1 27-10-19 2 2000 1 1 2 17-02-19 1 800 3 1 3 02-06-19 1 800 2 2 2 17-05-18 2 1000 oracle 3

We are refreshing a materialized view once every 3 hours or so. The query is not too complex and the view itself can be created in 30 seconds to 2 minutes.

I am running into performance issues using CONNECT BY NOCYCLE PRIOR in my query.

I am running into performance issues using CONNECT BY NOCYCLE PRIOR in my query.

I have installed oracle 19c database after installation product file not showing in oracle directory file
I need product folder for getting jar files from it and paste it on java jdk folder for database connection
How can i get this folder or i have to reinstall the database???

I am running an development Oracle DB on a computer in my network on port 1521. Our production environment is running on a different server in a different network. I want to copy my database via SQLDeveloper, so I have to connect to my development DB from the production server.

I have clearance orders and I need to SELECT orders information’s and only Head of department can see the orders this is the QUERY

What about 2 primary key for another tables like table a and table b and table c has the key of a and key b how ?

What about 2 primary key for another tables like table a and table b and table c has the key of a and key b how ?