Oracle Transaction - How To Create a Testing Table
Interview Question Database For Software Developers
|
|
| How To Create a Testing Table | | How To Create a Testing Table? - Oracle DBA FAQ - Understanding SQL Transaction Management | | By: FYIcenter.com | If you want to practice DML statements, you should create a testing table
as shown in the script below:
>cd (OracleXE home directory)
>.\bin\sqlplus /nolog
SQL> connect HR/fyicenter
Connected.
SQL> CREATE TABLE fyi_links (id NUMBER(4) PRIMARY KEY,
url VARCHAR2(16) NOT NULL,
notes VARCHAR2(16),
counts NUMBER(4),
created DATE DEFAULT (sysdate));
Table created.
You should keep this table for to practice other tutorial exercises presented in this collection.
| | ID: 890 | Rank: 1100 | Votes: 0 | Views: 48 | Submitted: 20070418 |
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view