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, 2162🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...