1
  • ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g

    I was trying to create a table with primary key based on two columns. Here is the create table statement: CREATE TABLE SECURITY_PASSWORD ( USER_NAME VARCHAR2 (25 BYTE) NOT NULL, USER_PASSWORD VARCHAR2 (25 BYTE) NOT NULL, CREATED_DATE DATE NOT NULL, CONSTRAINT security_password_pk PRIMARY_KEY...

    Techguys90 pointsBadges:
  • procedure create with compilation error ora-6550

    i created table staff with two column a number(3),b number(3) then created procedure p1 but it shows error as procedure created with compilation error & during insert ORA-6550 error at line 1 column 7 create table staff(fno number(3),lno number(3)); create or replace procedure p1 (a in number,b in...

    Yagnesh5 pointsBadges:
  • Msg 102, level 15, State 1, Line 14

    Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT...

    MasterK15 pointsBadges:
  • Create table by comparising 2 tables

    I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow tasks that are dates. I need a...

    Gooies5 pointsBadges:
  • How to create Dynamic DDS for a PF(Physical File In AS/400)

    How to create Dynamic DDS for a PF(Physical File In AS/400)

    Ugan5 pointsBadges:
  • Table creation in SQL Server 2005

    Hi, I need to prevent users to use CREATE TABLE but I need them to be able to execute a stored procedure that creates a table. Is it possible to allow users to create tables in SQL Server 2005 only through a stored procedure? Thanks in advance.

    Alediamo10 pointsBadges:
  • table storing in oracle 10g

    where does create table get stored in oracle 10g

    Chandan 0025 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following