| whts wrong in this???? [message #356710] |
Sat, 01 November 2008 04:42  |
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 #356721 is a reply to message #356714] |
Sat, 01 November 2008 06:57  |
aditya253058
Messages: 13
Registered: October 2008
|
Junior Member |
|
|
TAKE IT EASY
i am posting it again 
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 #356762 is a reply to message #356747] |
Sun, 02 November 2008 03:45 |
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 #356852 is a reply to message #356771] |
Sun, 02 November 2008 21:17 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
