Error At Line 1 Ora-00905 Missing Keyword
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn ora 00905 missing keyword case more about Stack Overflow the company Business Learn more about hiring developers or posting ora 00905 missing keyword case statement in where clause ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community ora 00905 missing keyword in oracle Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-00905: missing keyword (constraint foreign key) up vote -1 down ora 00905 missing keyword merge statement vote favorite hi everyone I'm completely new to SQL and I'm trying to answer this question in my book: 7.5 Write a CREATE TABLE statement for the EMPLOYEE table. Email is required and is an alternate key, and the default value of Department is Human Resources. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE. I'm running the query in Oracle iSQL*Plus, I successfully created the department table,
00905 Country Code
but when i tried creating the employee table while meeting these requirements I get the missing keyword error at line 12 constraint DepartmentFK FOREIGN KEY(DepartmentName), this is the whole query (I dropped the department table before attempting the whole thing, and it still gives the same error) CREATE TABLE DEPARTMENT ( DepartmentName char(35) NOT NULL, BudgetCode char(30) NOT NULL, OfficeNumber char(15) NOT NULL, Phone char(12) NOT NULL, Constraint DepartmentPK PRIMARY KEY(DepartmentName) ); CREATE TABLE EMPLOYEE ( ProjectID int NOT NULL, Name char(30) NOT NULL, Department char(15) NOT NULL, MaxHours int NOT NULL, StartDate char(8) NULL, EndDate char(8) NULL, Email char(30) DEFAULT 'Human Resources' NOT NULL, Constraint EmployeePK PRIMARY KEY(ProjectID), Constraint EmployeeAK1 UNIQUE(Email), constraint DepartmentFK FOREIGN KEY(DepartmentName), references DEPARTMENT(DepartmentName) ON UPDATE CASCADE ON DELETE no ACTION ); I tried following the most similar example in the book and looking up foreign key constraint and references but i can't understand why I'm getting this error... EDIT: I took out the comma but i still got these two errors: CREATE TABLE DEPARTMENT ( * ERROR at line 1: ORA-00955: name is already used by an existing object ON UPDATE CASCADE * ERROR at line 14: ORA-00905: missing keyword sql oracle share|improve this question edited Mar 9
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss
Ora-06512
the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn http://stackoverflow.com/questions/22278300/ora-00905-missing-keyword-constraint-foreign-key from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-00905: missing keyword when trying to create a synonym up vote 0 down vote favorite I have a problem when I try http://dba.stackexchange.com/questions/28538/ora-00905-missing-keyword-when-trying-to-create-a-synonym 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 I correct it? sql oracle oracle-sql-developer oracle-9i share|improve this question edited Nov 12 '12 at 10:08 Mat 6,55622234 asked Nov 12 '12 at 9:26 DevYudh 350412 1 As the documentation says, you can create sysnonyms in the current DB only. So the first @PACOMNET in the sysnonym name is unnecessary (and causing the error). –dezso Nov 12 '12 at 10:21 1 As an aside, you should probably sort your DB link names and sqlnet config out too. –Philᵀᴹ Nov 12 '12 at 11:11 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted As the documentation says implicitly, you can create synonyms in the current DB only. So the first @PACOMNET in the synonym name is unnecessary (and causing the error). You should instead connect to the PACOMNET database and run CREATE SYNONYM B2H.BILLING_USER_ACTIVITY FOR B2H.BILLING_USER_ACTIVITY@PACOMNET.US.ORACLE.COM; share|improve this answer answered Nov 12 '12 at 14:02 dezso 13.9k73462 add a comment|
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language https://www.techonthenet.com/oracle/errors/ora00905.php More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement https://www.tekstream.com/resources/ora-00905-missing-keyword/ Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION missing keyword UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-00905 Learn the cause and how to resolve the ORA-00905 error message in Oracle. Description When 00905 missing keyword you encounter an ORA-00905 error, the following error message will appear: ORA-00905: missing keyword Cause You tried to execute a statement, but you missed a required keyword. Resolution The option(s) to resolve this Oracle error are: Option #1 Try fixing the statement and re-executing. If you need to check out the proper syntax for your SQL statement, you can view the following pages: SELECT Statement INSERT Statement UPDATE Statement DELETE Statement Some other useful pages are: IN Condition UNION Query UNION ALL Query Subqueries Joins View a listing of all topics in Oracle. Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.
Digital Records Management Enterprise Content Management Strategy Digital Asset Management Oracle Imaging & Process Management Web Content Management Oracle WebCenter Portal Enterprise Portal Support Enterprise Portal Strategy Enterprise Portal Upgrade Oracle WebCenter Sites Sourcing Staffing & Recruiting Recruiting Managed Services Candidate Registration Technical Focus Client Opportunities Support Solutions Training Legacy to Oracle WebCenter Oracle Documents Cloud Service Next Generation AP Automation & Dynamic Discounting Oracle WebCenter Contract Lifecycle Management (CLM) Search ORA-00905: missing keywordYou are here: Home / Resources / ORA-00905: missing keyword ORA-00905 Error ORA-00905 is likely one you will see rather frequently while coding within Oracle. Fortunately, it is much more straightforward and easier to resolve than some of the other ORA errors you will run into while working in Oracle. In Oracle, there are certain words that have special meaning within the program: reserved words and keywords. (Namespaces are also another type of word that holds special meaning in Oracle but which is unrelated to the discussion of ORA-00905.) Reserved words are words that cannot be redefined and therefore, can never be used to define database objects such as columns or tables. These words are predefined by Oracle and will always hold their respective meanings as long as they are used. Keywords are words that also have special meaning to Oracle but those that are not reserved words and therefore, can be redefined. However, some keywords may later become reserved keywords and therefore, should be used with caution when executed as variable or function names. Here you will find a list of keywords. The Problem Error ORA-00905 is seen when a required keyword is missing. The error message will read: ORA-00905: missing keyword As the message suggests, your code is missing a keyword where there should be one in order for the query to run successfully. The Solution According to the Oracle documentation, the action for this error is to “correct the syntax.” Resolving ORA-00905 involves figuring out what keywor