Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

Thread: oracle 10 i password

  1. #16
    Join Date
    Jul 2003
    Posts
    421
    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.

  2. #17
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •