Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL varchar & varchar2
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


samar
varchar & varchar2
1 Answer(s)      4 years ago
Posted in : SQL


hii,

What is the difference between varchar & varchar2?


Advertisement
View Answers

October 28, 2010 at 4:29 PM


hello,

varchar2 and varchar both are support strings,

but varchar2 support alphanumeric string.and another one difference the total byte of the data type are differ.



Related Tutorials/Questions & Answers:
varchar & varchar2
varchar & varchar2  hii, What is the difference between varchar & varchar2?   hello, varchar2 and varchar both are support strings, but varchar2 support alphanumeric string.and another one difference the total
difference between varchar & varchar2?
difference between varchar & varchar2?  What is the difference between varchar & varchar2
Advertisements
Reply - Java Beginners
VARCHAR(100) PWDFFAMNT3 Number(10) PWDFFPURP4 Varchar2(100) PWDFFAMNT4 Number... USERCODE NUMBER(10) POSTDATE DATE FORMID VARCHAR2(20) LOCATIONID VARCHAR2(20) YRENDING NUMBER(10) REGNO VARCHAR2(20) LICENUMOFFACT VARCHAR2(50) SECT2Mi
foreign key error in sql
foreign key error in sql  create table matchdetails(mid varchar2(10),mdate date,team1 varchar2(10),team2 varchar2(10), stadium varchar2(10),city varchar2(10),mom varchar2(10),primary key(mid,mdate
Oracle - JDBC
control instead of the system. REPORT1 { id varchar2(5), name varchar2(25), description varchar2(1000), data BLOB } REPORT2 { id varchar2(5
runtime error:Invalid column name
NUMBER(5) PSTARTDATE VARCHAR(20) PENDDATE VARCHAR(20) SQL> desc EMS... VARCHAR2(50) TOPICDESC VARCHAR2(150) SQL
Writing a trigger for an userdefined datatype
the following columns DATATYPE :ADDRESS VARCHAR2(136) V_CODE VARCHAR2(8) T_CODE VARCHAR2(4) D_CODE VARCHAR2(2) PIN NUMBER(6) PHONE VARCHAR2(11) NOw I ill
Data types in a table
Data types in a table  hii, What are the data types allowed in a table?   hello,, These are the data types in table:- VARCHAR2, CHAR... types in table:- VARCHAR2, CHAR, NUMBER, RAW, DATE, LONG and LONG RAW
Processing stored procedure in MySQL - SQL
in number, inv_name1 out varchar2,inv_name2 out varchar2, inv_name3 out varchar2, inv_name4 out varchar2, inv_name5 out varchar2, inv_name6 out varchar2, inv_name7 out varchar2,inv_name8 out varchar2,inv_name9 out varchar2,inv_name10 out varchar2
Database
Database  Suppose i have created a table BOOKSHELF create table BOOKSHELF (Title VARCHAR2(100) primary key, Publisher VARCHAR2(20), CategoryName VARCHAR2(20), Rating VARCHAR2(2), constraint CATFK Foreign Key (CategoryName
SQL Alter Table
TO vendors; - Add Column ALTER TABLE supplier ADD ( supplier_name varchar2(50), city varchar2(45) ); - Modifiy Column ALTER TABLE supplier MODIFY ( supplier_name varchar2(100) not null, city varchar2(75) ); - Drop
Upload and display image and text records using JSP and Oracle
help me!! This is the table i have : RECORD: rollno: varchar2(20) name: varchar2(20) image blob Please help.. Need it urgently!! Thanks in advance
error log
Name: error_process columns: sno number int_name varchar2(40) err_descri varchar2(400
error log and send Database
-------------- Table Name: error_process columns: sno number int_name varchar2(40) err_descri varchar2(400
hi - SQL
NOT NULL VARCHAR2(20) PHONENO NUMBER VILLAGE VARCHAR2(15
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
Ajax
_NAME" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER
Ajax
" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE
jsp - Development process
jsp  table is as follow Usr_id varchar(7) Unchecked Usr_fname varchar(20) Unchecked Usr_mname varchar(20) Unchecked Usr_lname varchar(20) Unchecked Usr_email varchar(50) Unchecked Usr_res_phone varchar(20) Unchecked Usr
jsp code for dynamic time table generation - JSP-Servlet
`btech` ( `days` varchar(255) default NULL, `1` varchar(255) default NULL, `2` varchar(255) default NULL, `3` varchar(255) default NULL, `4
 

 

 

DMCA.com