Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In
Continue with Google
or use


Have an account? Sign In Now

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Sign Up Here
Continue with Google
or use

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask a question.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

Sorry, you do not have permission to add post.

Continue with Google
or use

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Oraask Logo Oraask Logo
Sign InSign Up

Oraask

  • Write
    • Add A New Post
    • Ask A Question

Oraask Navigation

Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
    • Oraask XML Formatter
    • Oraask JSON Formatter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Oracle SQL

This category lists all questions related to Oracle SQL database

Share
  • Facebook
6 Followers
57 Answers
85 Questions
Home/Database/Oracle SQL/Page 3
  • Recent Questions
  • Answers
  • No Answers

Oraask Latest Questions

Question
Rain
  • 0
RainExplorer
Asked: June 11, 2022In: Oracle Database, Oracle SQL

How to Use Limit in Oracle SQL

  • 0

How to Use Limit in Oracle SQL?

0
  • 0 0 Answers
  • 53 Views
  • 0 Followers
Answer
Question
Sanjeeb
  • 0
SanjeebExplorer
Asked: June 11, 2022In: Oracle Database, Oracle SQL

How to List all Tables in Oracle Database

  • 0

How to List all Tables in Oracle Database?

0
  • 0 0 Answers
  • 56 Views
  • 0 Followers
Answer
Question
TerryBittar
  • 0
TerryBittarExplorer
Asked: June 10, 2022In: Oracle SQL

What is a Primary Key in SQL

  • 0

0
  • 0 0 Answers
  • 39 Views
  • 0 Followers
Answer
Question
Ovilia
  • 0
OviliaExplorer
Asked: March 6, 2022In: Oracle SQL

Oracle SQL Query to Find User Permissions

  • 0

I need some help to find the current user login permissions he/she has.

1
  • 1 1 Answer
  • 214 Views
  • 0 Followers
Answer
Question
Garcia Gorry
  • 0
Garcia GorryExplorer
Asked: September 18, 2021In: Oracle SQL

ORA-01427: single-row subquery returns more than one row

  • 0

I have the following query that returns an error and i want to know what is the problem ? SELECT last_name, first_name FROM employees WHERE salary = (SELECT salary FROM employees WHERE department_id = 30); the error returned is : (SELECT salary FROM employees WHERE department_id ...

ORAora-01427
1
  • 1 1 Answer
  • 270 Views
  • 0 Followers
Answer
Question
Garcia Gorry
  • 0
Garcia GorryExplorer
Asked: September 18, 2021In: Oracle SQL

ORA-01417: a table may be outer joined to at most one other table

  • 0

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

ORAora-01417
1
  • 1 1 Answer
  • 309 Views
  • 0 Followers
Answer
Question
Garcia Gorry
  • 0
Garcia GorryExplorer
Asked: September 17, 2021In: Oracle SQL

Issue with grant SELECT privilege to Oracle database user

  • 0

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

0
  • 0 0 Answers
  • 108 Views
  • 0 Followers
Answer
Question
kenDonald
  • 0
kenDonaldJunior
Asked: August 26, 2021In: Oracle SQL

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

  • 0

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

1
  • 1 1 Answer
  • 516 Views
  • 0 Followers
Answer
Question
Richard
  • 0
RichardExplorer
Asked: August 15, 2021In: Oracle SQL

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

  • 0

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

0
  • 0 0 Answers
  • 114 Views
  • 0 Followers
Answer
Question
Alan
  • 0
AlanExplorer
Asked: February 19, 2021In: Oracle SQL

How to grant read and write on directory in oracle ?

  • 0

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.

directory grant permissionoracle directory
1
  • 1 1 Answer
  • 7k Views
  • 0 Followers
Answer
1 2 3 4 … 9

Sidebar

Adv 250x250

Explore

  • Categories
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Dev Tools
    • Online Compiler
    • Base64 Converter
    • Oraask XML Formatter
    • Oraask JSON Formatter
  • Wiki
    • SQL Tutorials
    • Java Tutorials
    • Python Tutorials
    • JavaScript Tutorials

Footer

Oraask

About

Oraask is a website for developers and software engineers who want to learn new skills, share their knowledge, and solve their coding problems. Oraask provides free content on various programming languages and topics, such as Oracle, Python, Java, etc. Oraask also allows users to ask questions and get answers from other members of the community.

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Privacy Policy
  • Terms & Conditions

Follow

Oraask is licensed under CC BY-NC-SA 4.0Oraask CopyrightOraask CopyrightOraask CopyrightOraask Copyright

© 2019 Oraask. All Rights Reserved
With Love by Oraask.