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.
⇒ Commit the Current Transaction in Oracle
⇐ Ways to End the Current Transaction in Oracle
2019-09-04, 3798🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table in Oracle? The simplest query statement is the on...
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundati...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Start the Command-Line SQL*Plus in Oracle? If you Oracle server or client installed on your w...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...