How to Use Limit in Oracle SQL?
Oraask Latest Questions
How to List all Tables in Oracle Database?
I need some help to find the current user login permissions he/she has.
I am working on Oracle database 11g, and facing an issue while trying to execute the following query: SELECT d.department_name, e.manager_id, l.location_id, sum(e.salary) FROM departments d, employees e, locations l WHERE d.department_id = e.department_id AND e.manager_id = d.manager_id (+) AND l.location_id = d.location_id (+) GROUP BY ...
We have the following table and views and we need to grant SELECT to other database user to be able to SELECT from those objects. This is the list of the table and view FND_RESPONSIBILITY_VL FND_USER FND_USER_RESP_GROUPS_DIRECT the normal command to grant SELECT to other ...
I am getting this error while updating a table in the oracle database 11g ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
I have express database running on windows machine, while trying to export the database facing this error: ORA-12514 TNS:listener does not currently know of service requested in connect descriptor Note: I check below things but still the issue exists : 1 - SQLPLUS ...
hello guys, What is the command to grant read/write permission on an oracle directory ? to be able to write files or read some data from.