Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Create a New Table
How To Create a New Table? - Oracle DBA FAQ - Understanding SQL DDL Statements
✍: FYIcenter.com
If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table:
>.\bin\sqlplus /nolog SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80) NOT NULL, 3 description VARCHAR(256) NOT NULL, 4 create_date DATE DEFAULT (sysdate)); Table created.
This scripts creates a testing table called "tip" with 4 columns in the schema associated with the log in account "HR".
2007-04-22, 4490👍, 0💬
Popular Posts:
How you will enable front-end validation based on the xml in validation.xml? The <html:javascr...
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
Does there exist any other function which can be used to convert an integer or a float to a string? ...