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 New Table in Your Schema
How To Create a New Table in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: 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-05-03, 4893👍, 0💬
Popular Posts:
How can I use tables to structure forms Small forms are sometimes placed within a TD element within ...
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML ...
What is the result of using Option Explicit? When writing your C program, you can include files in t...
How do we host a WCF service in IIS? Note: - The best to know how to host a WCF in IIS is by doing a...
Assuming that the structure of a table shows two columns like this: --------+------------+-- ----+---...