tag:blogger.com,1999:blog-8873109125023142810.post6353492968821455521..comments2024-03-29T13:16:28.902+05:30Comments on Let's Develop in Oracle: ORA-00911: invalid characterNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-8873109125023142810.post-46781600588194039852022-02-24T00:02:47.966+05:302022-02-24T00:02:47.966+05:30There are many different ways to entertain your pa...There are many different ways to entertain your party guests at a birthday party. One of the most common ways is to have a costume character walking around. But some children, including the birthday boy or girl, can be scared. <a href="https://g.page/r/CQJ-dv1hkJzEEAE" rel="nofollow">hora loca</a><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-72948736702205277042022-02-10T10:55:12.538+05:302022-02-10T10:55:12.538+05:30Panther spirit people encourage others positively ...Panther spirit people encourage others positively through their own zest for life and quest for realizing ones dreams and desires. Panther reminds us to release our fears acknowledge our own power and accept our dark shadow selves. <a href="https://thepartycharacters.com/black-panther/" rel="nofollow">Black Panther for birthday</a><br />AlayaSEOhttps://www.blogger.com/profile/08786653889666434898noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-44906588670478945192019-04-21T22:18:08.132+05:302019-04-21T22:18:08.132+05:30create table Boat(bid number(3) primary key,bname ...create table Boat(bid number(3) primary key,bname varchar2(30),bcolor varchar2(30));<br />insert into Boat values (1,'Misty','Red');<br /><br />WHAT IS WRONG IN THE SECOND LINE?Anonymoushttps://www.blogger.com/profile/07464773556754497188noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-32493473408309144982018-09-13T19:11:07.100+05:302018-09-13T19:11:07.100+05:30kya time waste kar rha hai bhai
kya time waste kar rha hai bhai<br />Anonymoushttps://www.blogger.com/profile/17667708632759787125noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-33043013847985104842018-09-06T19:45:29.758+05:302018-09-06T19:45:29.758+05:30I AM GETTING THE ERROR WHEN I AM CREATING A TABLE ...I AM GETTING THE ERROR WHEN I AM CREATING A TABLE HELP!!!!!!!!!!!!!!<br />CREATE TABLE "revtmdb.pp_glrpt_variable" <br /> ( <br /> company NUMBER(4) NOT NULL, <br /> r_name CHAR(2 byte) NOT NULL, <br /> currency_code CHAR ( 5 byte) NOT NULL, <br /> site_id CHAR (5 byte) NOT NULL, <br /> fiscal_year NUMBER (4) NOT NULL, <br /> acct_period NUMBER(2) NOT NULL, <br /> r_system CHAR(2 byte) NOT NULL, <br /> posting_date DATE NOT NULL, <br /> je_type CHAR(1 byte) NOT NULL, <br /> control_group NUMBER (8), <br /> invoice # NUMBER(8), <br /> report name CHAR(2 byte) NOT NULL, <br /> report DESC CHAR (2 byte) NOT NULL, <br /> gl_trans DESC CHAR(2 byte) NOT NULL, <br /> acct_unit CHAR (15 byte) NOT NULL, <br /> acct_unit_desc CHAR(30 byte) NOT NULL, <br /> person_resp CHAR(15 byte) NOT NULL, <br /> var_levels CHAR (30 byte) NOT NULL, <br /> account NUMBER(6) NOT NULL, <br /> gl_acct_desc CHAR (30 byte) NOT NULL, <br /> beg_amount NUMBER (18,2) NOT NULL, <br /> glt_fields CHAR(30 byte) NOT NULL, <br /> glt_debit_amt NUMBER (18,2) NOT NULL, <br /> glt_credit_amt NUMBER (18,2) NOT NULL, <br /> end_amount NUMBER (18,2) NOT NULL, <br /> )Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-72995876646254496822018-03-13T12:00:31.575+05:302018-03-13T12:00:31.575+05:30Thanks for finally writing about >"ORA-009...Thanks for finally writing about >"ORA-00911: invalid character" <br /><Loved it!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-23751408650926390802017-08-24T18:14:34.318+05:302017-08-24T18:14:34.318+05:30Admiring the time and effort you put into your blo...Admiring the time and effort you put into your blog and iin depth <br />information you provide. It's good to come across a blog every onhe in a while that isn't tthe same out off date rehashed material.<br /><br />Excellent read! I've bookmarked your site and I'm including your RSS feeds to my Google <br />account.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-20711540130420023482016-05-10T18:55:46.224+05:302016-05-10T18:55:46.224+05:30Thank You Very Much....Help of this site i solve m...Thank You Very Much....Help of this site i solve my problem.Naimul hasan shohan, ID :-201320335https://www.blogger.com/profile/14384099440785785947noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-40564737715764952072016-03-14T13:01:01.620+05:302016-03-14T13:01:01.620+05:30use to_date() as in example for handling datesuse to_date() as in example for handling datesNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-46984096737739828412016-03-14T10:20:48.658+05:302016-03-14T10:20:48.658+05:30Now when I go to make my Union I get this ?
SQL&g...Now when I go to make my Union I get this ?<br /><br />SQL> SELECT * FROM(<br /> 2 SELECT l1.LAST_NAME, l1.FIRST_NAME, l1.HIRE_DATE AS OLD_TIMERS, '' AS NEWER<br />_HIRES<br /> 3 FROM L_EMPLOYEES l1<br /> 4 where l1.HIRE_DATE < (#01-01-2000#) and l1.HIRE_DATE is not null<br /> 5 union all<br /> 6 SELECT l2.LAST_NAME, l2.FIRST_NAME, '' AS OLD_TIMERS, l2.HIRE_DATE AS NEWE<br />R_HIRES<br /> 7 FROM L_EMPLOYEES l2<br /> 8 where l2.HIRE_DATE >= (#01-01-2000#) and l2.HIRE_DATE is not null<br /> 9 );<br />where l1.HIRE_DATE < (#01-01-2000#) and l1.HIRE_DATE is not null<br /> *<br />ERROR at line 4:<br />ORA-00911: invalid character<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-44987300444529692822016-03-14T10:19:15.879+05:302016-03-14T10:19:15.879+05:30SQL> UPDATE L_EMPLOYEES set Old_Timer = HIRE_DA...SQL> UPDATE L_EMPLOYEES set Old_Timer = HIRE_DATE<br /> 2 where HIRE_DATE < TO_DATE('01-01-2000','DD-MM-YYYY');<br /><br />3 rows updated.<br /><br />I changed it to that and it workedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-66933276422710942352016-03-14T08:58:10.279+05:302016-03-14T08:58:10.279+05:30I hope you have L_EMPLOYEES table withe TIMER VARC...I hope you have L_EMPLOYEES table withe TIMER VARCHAR2 and HIRE_DATE DATE column, use following query<br />UPDATE L_EMPLOYEES set timer = 'Old Timer' <br />where HIRE_DATE < TO_DATE('01-01-2000','DD-MM-YYYY');<br />Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-57799296242932903952016-03-14T08:38:11.969+05:302016-03-14T08:38:11.969+05:30Keep getting the ORA-00911 error in Oracle and hav...Keep getting the ORA-00911 error in Oracle and have tried several different variants<br /><br />UPDATE L_EMPLOYEES set timer = 'Old Timer' <br />where HIRE_DATE < 01-01-2000#;<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-13769001744375363802015-01-14T20:12:12.466+05:302015-01-14T20:12:12.466+05:30you need to put the comment inside statement i.e. ...you need to put the comment inside statement i.e. before ; like<br />SELECT COUNT(*) FROM SATURN.SPRTELE WHERE SPRTELE_PIDM = 90384408 --1; Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-57417650116091212692015-01-14T04:11:34.350+05:302015-01-14T04:11:34.350+05:30Why is this error happening when there is a commen...Why is this error happening when there is a comment on the line? <br />SELECT COUNT(*) FROM SATURN.SPRTELE WHERE SPRTELE_PIDM = 90384408; --1<br />The --1 causes the 00911 error. Why?Marvin Buddhttps://www.blogger.com/profile/12801194666747813698noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-8429056780602886872014-06-06T21:06:24.798+05:302014-06-06T21:06:24.798+05:30Very useful post thank you very muchVery useful post thank you very muchAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-2299642211603666972014-01-15T00:36:55.694+05:302014-01-15T00:36:55.694+05:30Good summary, Thank you for the post.
PraveenGood summary, Thank you for the post.<br />PraveenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-37779757808339699522014-01-07T20:20:18.064+05:302014-01-07T20:20:18.064+05:30in my case it was an syntax error in the mapping (...in my case it was an syntax error in the mapping (.hbm.xml) Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-77932299113973753792013-09-17T14:57:12.880+05:302013-09-17T14:57:12.880+05:30Nice Post !!
Thanks For Sharing it.Nice Post !!<br />Thanks For Sharing it.Sandeep Bhadauriyahttp://devssolution.comnoreply@blogger.com