Solved

ORA-00995

Posted on 2006-06-25
9
750 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]
Comment Utility
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
Comment Utility
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]
Comment Utility
>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
 
LVL 8

Expert Comment

by:sapnam
Comment Utility
If you give desc gis.period_info in SQL, do you get the description.  
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 16

Expert Comment

by:MohanKNair
Comment Utility
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
Comment Utility
Please ignore the above comments
0
 
LVL 3

Accepted Solution

by:
cdemir earned 50 total points
Comment Utility
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 31

Expert Comment

by:awking00
Comment Utility
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
Comment Utility
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.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

743 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now