Home » Developer & Programmer » Application Express & MOD_PLSQL » whts wrong in this????
whts wrong in this???? [message #356710] Sat, 01 November 2008 04:42 Go to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
when i try to run the following code on http://apex.oracle.com/ , i get the error ORA-00911: invalid character

CREATE TABLE DEPT123(
DEPTNO NUMBER(10) CONSTRAINT Dept_Pkey Primary Key,
DNAME Varchar2(20),
LOC Varchar2(20));

INSERT INTO DEPT123
(DEPTNO,DNAME,LOC)
VALUES (10,'accounting','newyork');

SELECT *
FROM DEPT123;

i hav serched abt this error and i m not doing any mistake as per their descriptions
furthur whn i emailed this code to a frnd running oracle,the code executed without any prblm

i even read the supprt document of apex.oracle site

but still i m not able to run it

(i m running it in SQL commnd section,is it right OR commnds r run in any othr section??????)



p.s. is there any way to delete history in apex.oracle site????
Re: whts wrong in this???? [message #356714 is a reply to message #356710] Sat, 01 November 2008 05:47 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is one of the worst posts I've ever seen.

Just in case you didn't know, English is a standard language in the main OraFAQ Forum section. You may use Spanish, French, Dutch etc. if you wish - there are sub-forums dedicated to people who use these languages as their native tongues; they can be found at the bottom of the main OraFAQ Forum page.

However, you seem to be talking English, but that is an utter mess and I will certainly not even try to understand what you might have been asked.

"hav serched abt whn frnd prblm supprt commnds r othr" are not welcome here.
Re: whts wrong in this???? [message #356721 is a reply to message #356714] Sat, 01 November 2008 06:57 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
TAKE IT EASY
i am posting it again Smile

when i try to run the following code on http://apex.oracle.com/ , i get the error ORA-00911: invalid character

CREATE TABLE DEPT123(
DEPTNO NUMBER(10) CONSTRAINT Dept_Pkey Primary Key,
DNAME Varchar2(20),
LOC Varchar2(20));

INSERT INTO DEPT123
(DEPTNO,DNAME,LOC)
VALUES (10,'accounting','newyork');

SELECT *
FROM DEPT123;

i have searched about this error and i m not doing any mistake as per their descriptions
further when i emailed this code to a friend running oracle,the code executed without any problem

i even read the support document of apex.oracle site

but still i m not able to run it

(i m running it in SQL command section,is it right OR commands r run in any other section??????)



p.s. is there any way to delete history in apex.oracle site????
Re: whts wrong in this???? [message #356738 is a reply to message #356721] Sat, 01 November 2008 20:40 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

when you are running in apex sql command section terminating symbal ; (semicolon) is not required on the last statement.

yours
dr.s.raghunathan
Re: whts wrong in this???? [message #356747 is a reply to message #356721] Sun, 02 November 2008 00:52 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
when i remove semicolons i get the following error
ORA-00922: missing or invalid option
Re: whts wrong in this???? [message #356762 is a reply to message #356747] Sun, 02 November 2008 03:45 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,
i submitted the script in apex script section which is available in sql workshop
CREATE TABLE DEPT123(
"DEPTNO" NUMBER(10), 
"DNAME" Varchar2(20),
"LOC" Varchar2(20),
CONSTRAINT "Dept_Pkey" Primary Key("DEPTNO")
);

insert into dept123 (deptno,dname,loc) values (10,'yyy','xxx');

select * from dept123;




it works fine.

yours
dr.s.raghunathan

in sql command section also one by one i gave it without ; It works fine.
Re: whts wrong in this???? [message #356771 is a reply to message #356762] Sun, 02 November 2008 04:18 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
thank you very much Smile
now i am using the script section(i save the code in text file and then upload it ,and the run it)
(if i run the same code in command section its still giving errors,but anyhow my purpose is served)

is there any way i can delete history in in that site??
Re: whts wrong in this???? [message #356813 is a reply to message #356771] Sun, 02 November 2008 10:56 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm glad you found the solution for the problem.

Quote:
is there any way i can delete history in in that site??
What "history" do you have on mind? If it is about your previous posts - no, you can't do that. Your account? I don't think it is possible either. Something different? If so, what exactly? Perhaps moderators can help (or, if not, know who might do that).
Re: whts wrong in this???? [message #356815 is a reply to message #356813] Sun, 02 November 2008 11:02 Go to previous messageGo to next message
aditya253058
Messages: 13
Registered: October 2008
Junior Member
u have only read my last post,read the earlier posts
i have clearly written history in apex.oracle site
this is the one on "my mind"
Re: whts wrong in this???? [message #356817 is a reply to message #356815] Sun, 02 November 2008 11:13 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
True; I apologize. Unfortunately, I wouldn't know the answer.
Re: whts wrong in this???? [message #356852 is a reply to message #356771] Sun, 02 November 2008 21:17 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

i have very little rememberance that there was some default settings are available for history clearing as 30 days. I am not sure. I also think that the settings can be changed through some dos prompt editable files. Exactly i do not remember. I like to know whether your history settings prevail more than 30 days too.
yours
dr.s.raghunathan
Previous Topic: page can not found
Next Topic: More than 2 columns as PK
Goto Forum:
  


Current Time: Thu Dec 25 09:50:08 CST 2014

Total time taken to generate the page: 0.05752 seconds