|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 3rd, 2009, 11:44 PM
|
|||
|
|||
Query help required...urgently...within 1 hr
select column_name,data_type from information_schema.columns where table_name = 'emp';
the above code give the columns name and its datatype as output.... What is the query for getting the size of the datatype along with the column name and datatype?? eg: name datatype size roll int 4 college char 20 . i hope u got an idea.....plzz help me fast. 
|
|
#2
November 4th, 2009, 08:50 AM
|
||||
|
||||
|
Did the teacher let you in the classroom with an iPhone?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Query help required...urgently...within 1 hr |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
