Tagged Questions
-1
votes
2answers
73 views
Combine two SQL statements to a single statement [closed]
My question is related to SQL. I need to pull values from two different tables. I am not successful in doing that. I am able to join the two tables with only a single condition but not many values ...
0
votes
3answers
369 views
ORA-00905: missing keyword when trying to create a synonym
I have a problem when I try to create a synonym like this:
CREATE SYNONYM B2H.BILLING_USER_ACTIVITY@PACOMNET
FOR B2H.BILLING_USER_ACTIVITY@PACOMNET.US.ORACLE.COM;
Why does this happen and how can ...
-4
votes
1answer
1k views
primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]
EMPLOYEES TABLE
COLUMN NAMES:
EMPLOYEE_ID
EMPLOYEE_NAME
EMPLOYEE_LASTNAME
JOB
EMPLOYEE_BUSINESS_PHONE
EMPLOYEE_GSM
SALARY
HIRE_DATE
E_MAIL
DEPARTMAN_NO
NOTE:FOR THIS TABLE: EMPLOYEE_ID IS PRIMARY ...
2
votes
0answers
210 views
SQL Developer Data Modeller and Data Dictionary question
I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
