HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
Answers were Sorted based on User's Feedback
Answer / prativa mishra
begin
execute immediate('alter table table_name add constraint constraint_name primary key(column_name)');
end;
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / prativa mishra
BEGIN
EXECUTE IMMEDIATE 'ALTER TABLE TABLE_NAME ADD CONSTRAINT PK1
PRIMARY KEY(COLUMN_NAME)';
END;
| Is This Answer Correct ? | 2 Yes | 0 No |
who introduced sql?
What is #table in sql?
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)
is it necessary to write group by and order by clause together
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
What is the life of an sql statement?
Write a query to find the names of users that begin with "um" in sql?
Types of joins ?
What is trigger explain it?
How to check if a column is nullable before setting to nullable?
I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On
Is progress software supports to ( pl/sql )?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)