CODEWITHSUNDEEP
sqloracle-database
facebook
facebook

Reputation: 1864

create table in sql

I am getting an error when I attempt to run this query:

create table New_Table as  
select NAme  
from File_name, FileType  
where File_name.name = FileType.Name

Here is the error I am getting:

"ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows"

Any idea why?

Upvotes: 1

Views: 185

Answers (1)

Casey Patton
Casey Patton

Reputation: 4091

Is NAme a separate field from file_name.name and filetype.name? If not, you would need to specify file_name.name or filetype.name in your SELECT statement.

Upvotes: 2

Related Questions