Linked Questions

i created a sequence using the following query, create sequence qname_id_seq start with 1 increment by 1 nocache; Now when i try to create a table which uses the above sequence, it is throwing the ...

I want to add a new auto increment primary column to a existing table which has data. How do I do that? I first added a column and then try to add a sequence after that, I lost how to insert and make ...

What is the magical incantation to create an identity column in Oracle?

I keep being told I am missing a right parenthesis but I'm not seeing it, can anybody point it out? CREATE TABLE Member ( MEMBER_ID int NOT NULL AUTO_INCREMENT , FIRST_NAME varchar(255) NOT NULL , ...

I am facing issue while inserting multiple row in one go into table because column id has primary key and its created based on sequence. for ex: create table test ( iD number primary key, name ...

this is my code. but i don't know where is the mistakes since i used 11g express edition. it shows error but no show which line the error CREATE TABLE hsstaff ( staff_ID int NOT NULL AUTO_INCREMENT, ...

I have some table and trying load data into it by selecting row from another table like below. insert into emp2(eid,ename,sal,my_seq_num) select eid,ename,sal from emp1; When I executed the above ...

1.we can use "identity(Start_Value,Increase)" key word in SQL Server to auto increment filed. so, such like that any key word is available in Oracle 10g. if any body know that give me ans... and if ...

I have a table which doesn't have an ID. So I want to add a new column which is 1 to total row number. I opened a new column in the table but I don't know how to fill it with row count. I searched on ...

I'm relatively new to Oracle but I'm getting an error, ORA-00922, when I'm trying to execute the following statement: CREATE TABLE RT_action_items ( action_itemID INT NOT NULL AUTO_INCREMENT, ...

I am trying to create a table, but keep getting the following error message: Warning: oci_execute(): ORA-00907: missing right parenthesis in ... on line 14 The following is the code that deals with ...

I am facing the issue while creating the Table in SQL, CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25), LAST_NAME CHAR(25), SALARY INT(15)...

Can anyone help me to auto-generate the empID field, so that we don't enter the value through the insert statement. ...

CREATE TABLE Persons ( ID int NOT NULL AUTO_INCREMENT, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (ID) ) Error starting at line 1 in ...

I'm using oracle 11g xpress. I have created a simple table. I want that field each time a user inputs data to be incremented by 1, starting from 10000. Can you assist? My table is this: CREATE TABLE ...