-
CREATE SEQUENCE sq;
CREATE TABLE t_test(
id INTEGER PRIMARY KEY,
name VARCHAR(10)
);
INSERT INTO t_test(id,name)
VALUES (sq.nextval,'Andrew');
INSERT INTO t_test(id,name)
VALUES (sq.nextval,'Gordon');
SELECT * FROM t_test;
select owner, object_name from dba_objects where object_name ='t_test'
________
MEDICAL MARIJUANA STATES
Last edited by sql; 03-06-2011 at 01:55 AM.
-
Which id did you use to login to Oracle? What's default schema for that id?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|