ORA-00942: table or view does not exist

Question

1.00/5 (1 vote)

See more:

i have created table and inserted record but in join query showing error.

What I have tried:

select gi.group_members as ID, em.EMP_NAME as NAME, em.EMAIL_ID as EMAIL , v.DIR_MOBILE
from groupinfo gi 
join emp_master em on gi.group_members= '3'|| EMP_NO || '0' 
join V_EMP_MOBILE v on v.DIR_EMP_NO='3'|| EMP_NO || '0'
and group_name='oper';

Posted 10-Oct-18 1:08am

Darsh12345

Updated 10-Oct-18 2:42am

Add a Solution

Comments

CHill60 10-Oct-18 7:17am

What error?
What happens if you query the table directly?

jsc42 10-Oct-18 8:06am

As @CHill60 says, What error?

There are a million and one possible error each with different causes.

My wide guess is that you have fields EMP_NO and / or group_name present in multiple tables so Oracle doesn't know which one to use. Try using qualified names, e.g. em.EMP_NO and gi.group_name (if they are in emp_master and groupinfo respectively, otherwise adjust as required).
Or is EMP_NO numeric? In which case you may need to cast / convert to text if gi.group_members and v.DIR_EMP_NO are texts; otherwise if they are all numbers, convert the concatenated string expressions to arithmetic expressions (exact formula depends on whether EMP_NO has a constant no of digits excluding leading zeros or not).

In summary ... please supply more information as we cannot guess exactly what you arte trying to do.

I'll leave it to someone else to comment on using expressions rather than simple column names in join clauses.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-10-10T02:43:00

Solution 1

Check out this: Oracle / PLSQL: ORA-00942 Error Message[^]
There you'll find few options how to resolve this issue.

Posted 10-Oct-18 2:43am

Maciej Los