BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan Right Header

Register FAQ Community Calendar New Posts Navbar Right Corner
HOME BZU Mail Box Online Games Radio and TV Cricket All Albums
Go Back   BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan > Institute of Computing > Bachelor of Science in Information Technology > BsIT 4th Semester > Introduction to Database

Introduction to Database By Sir Yousaf


Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 12-03-2009, 04:54 AM
.BZU.'s Avatar


 
Join Date: Sep 2007
Location: near Govt College of Science Multan Pakistan
Posts: 9,693
Contact Number: Removed
Program / Discipline: BSIT
Class Roll Number: 07-15
.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute
Lightbulb What is the difference between char,varchar2? Oracle table creation

Char is stored as a fixed length string, Varchar2 is stored as a variable
length string. Thus, if you define the table:
Code:
create table mytable (
charfield Char(50),
varfield Varchar2(50));
If you perform the following insert: Insert Into mytable
(charfield,varfield) Values ('Hello','Hello');
The first fields will take 50 bytes while second will take only 5. It is
usually recommended to store strings as varchar.
__________________
(¯`v´¯)
`*.¸.*`

¸.*´¸.*´¨) ¸.*´¨)
(¸.*´ (¸.
Bzu Forum

Don't cry because it's over, smile because it happened
Reply With Quote
Reply

Tags
char, creation, difference, oracle, table, varchar2


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IQ test: Char zero ek saat likho.. usman_latif_ch Funny Cut Piece 0 09-12-2011 02:18 PM
Binary Table 01 Geeky Table .BZU. Designed Pictures 0 28-04-2011 05:10 AM
Get Trained in Oracle by Oracle in Pakistan! BSIT07-01 Alumni/Careers/Jobs 0 28-09-2009 03:07 PM
Excel Creation... usman_latif_ch Chit Chat 3 09-05-2009 05:30 PM
Assignment For table and Farme creation in XHTML (lecture 12) .BZU. Web Development 2 30-10-2007 11:33 PM

Best view in Firefox
Almuslimeen.info | BZU Multan | Dedicated server hosting
Note: All trademarks and copyrights held by respective owners. We will take action against any copyright violation if it is proved to us.

All times are GMT +5. The time now is 01:17 PM.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.