Interested to Buy Any Domain ? << Click Here >> for more details...
What are the pre requisites?
- 1 Answers
- 5613 Views
- I also Faced
- E-Mail Answers
Answer / guest
I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?
To Modify the datatype of a column the column must be empty.
To add a column with NOT NULL constrain, the table must be
empty.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is dialect in sql?
What is normalization in sql?
Which is faster subquery or join?
Why do we need a foreign key?
What program will open a mdb file?
What are basic techniques of indexing?
What is the importance of sqlcode and sqlerrm?
what are tables and fields? : Sql dba
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
Enlist the characteristics of pl/sql?
Why primary key is required?
Which is better stored procedure or query?
-
Oracle (3253) - 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)
