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, 5003👍, 0💬
Popular Posts:
What is the difference between Class and structure’s ? Following are the key differences between the...
The following variable is available in file1.c, who can access it? static int average; Answer: all t...
How To Process Query Result in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL You can run queries...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
If we have two version of same assembly in GAC how do we make a choice ? OK first let’s try to under...