Solved

ORA-00995

Posted on 2006-06-25
9
764 Views
Last Modified: 2012-06-27
select NAME into str11
  from gis.period_info
  where name='SP500TR88I' and
sdate='21-JUN-06' and deleted='N';


ERR:  missing keyword

why i am getting this error .
0
Comment
Question by:avi_ny
  • 2
  • 2
  • 2
  • +3
9 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16979779
select [NAME] into str11
  from gis.period_info
  where [name]='SP500TR88I' and
sdate='21-JUN-06' and [deleted]='N';
0
 

Author Comment

by:avi_ny
ID: 16979796
This code is a part of PL/SQL.
I made your suggested changes it is not working that way.
Thanks for help.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16979978
>This code is a part of PL/SQL.
can you post a bit more of that pl/sql. if it's large, only some lines above and below yours...

also: ORA-00995:      missing or invalid synonym identifier

it looks to me that it's not THAT statement issing the error, but rather a CREATE or DROP SYNONYM.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 8

Expert Comment

by:sapnam
ID: 16981100
If you give desc gis.period_info in SQL, do you get the description.  
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 16981430
One option is to query the data dictionary views and generate the DDL scripts.

See the link below
http://www.dbasupport.com/oracle/scripts/Detailed/279.shtml

orafaq
http://www.orafaq.com/scripts/sql/cre8like.txt
0
 
LVL 16

Expert Comment

by:MohanKNair
ID: 16981431
Please ignore the above comments
0
 
LVL 3

Accepted Solution

by:
cdemir earned 50 total points
ID: 16982154
can you try this :

sdate = to_date('21-JUN-06','DD-MMM-YY')

OR

to_char(sdate,'DD-MMM-YY') = '21-JUN-06'
0
 
LVL 32

Expert Comment

by:awking00
ID: 16992659
cdemir has a point, although if sdate has a time element, you need
trunc(sdate) = to_date('21-JUN-06','DD-MMM-YY')
0
 

Author Comment

by:avi_ny
ID: 16995936
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 78
Oracle - SQL Query with Function 3 37
Create Index on a Materialized View 5 24
Where Does Time Value Come From for Database Insert or Update 4 28
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question