Help-creating table

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Tue, 29 Apr 2008 4:38 pm

Guys, I need to create a table with the same Access information with the following attributes: Extension-Password long integer date/time date Duration Call-call-Type date/time text (14) dialed number-text (20) Situation-text (1) cost (double)-Extension-Operator long integer long integer As create for Oracle?
Location: Porto Alegre - RS

Poston Wed, 30 Apr 2008 11:26 am

Code: Select all
Create table Tbl_name COLUMN ( TIPO_COLUNA, )
data types that you will use DATE-date and time VARCHAR2 (X)-Text with X positions NUMBER (X)-X numeric positions.
NUMBER (X, Y)-the real Numerius, float, with X and Y positions decimals.
Location: Patos de Minas - MG

Alexandre Matos
Patos de Minas - MG
Do interior de Minas para o resto do Mundo

  • See also
    Last Post

Return to SQL

Who is online

Users browsing this forum: No registered users and 4 guests