Collections:
Create a Test Table for Transaction Testing in Oracle
How To Create a Test Table for Transaction Testing in Oracle?
✍: 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.
2019-09-04, 1354👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...