Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Create a Testing Table
How To Create a Testing Table? - Oracle DBA FAQ - Understanding SQL Transaction Management
✍: 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.
2007-04-18, 5764👍, 0💬
Popular Posts:
What is Concern in AOP? gA concern is a particular goal, concept, or area of interesth There are m...
How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...
How To Export Your Connection Information to a File? - Oracle DBA FAQ - Introduction to Oracle SQL D...
How does multi-threading take place on a computer with a single CPU? The operating system's task sch...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...