I need my query to run faster, and I don’t understand why it’s doing a table scan
I’m struggling with how to improve my queries. Here’s the scenario.
Select an unaffected row from table to use in trigger
What I have is a database table CODE that is used to store various types of codes in the application. Due to customer requirements, I must now write a trigger on that table that creates a row to another table, that references two rows in the code table: the inserted/updated row and a second row.
how to use query condition in Oracle REST Data Services?
I can use url like http://ip_port/ords/table/?q={“id”:111} to query db by “id=111”,
but I don’t know how to query max(id), and is there any way to query by entire SQL(such as select …from table_name)?
Unable to view the OK and CANCEL buttons at the bottom of this Insert Table/Form Screen in Oracle BI Publisher Desktop
Unable to view the OK and CANCEL buttons at the bottom of this Insert Table/Form Screen in Oracle BI Publisher Desktop.
Encryption of PII data in database logic in store procedures and desktop application
I have an old desktop application (Delphi) with logic in stored procedures (Oracle). The application is storing some personal data including salaries. I want to encrypt data so someone with db access cannot check salaries of other workers. I face 2 problems:
Who is responsible for updating the Java API and how can other individuals contribute?
I made a search on google to find out who are the people in Oracle responsible for updating the Java API in other words who are those responsible for adding new classes and methods to the API and updating the Java Documentation.
Who is responsible for updating the Java API and how can other individuals contribute?
I made a search on google to find out who are the people in Oracle responsible for updating the Java API in other words who are those responsible for adding new classes and methods to the API and updating the Java Documentation.
Who is responsible for updating the Java API and how can other individuals contribute?
I made a search on google to find out who are the people in Oracle responsible for updating the Java API in other words who are those responsible for adding new classes and methods to the API and updating the Java Documentation.
Who is responsible for updating the Java API and how can other individuals contribute?
I made a search on google to find out who are the people in Oracle responsible for updating the Java API in other words who are those responsible for adding new classes and methods to the API and updating the Java Documentation.
find the missing sequence in Oracle DB
I have a table date, store code, do_no. some stores have missing sequence number. Data looks like Source. I’m not able to find missing doc_no in all stores. Each store doc_no start digit is different. STO1 starts wth 1, ST02 start with 2,ST03 3 etc..