varchar & varchar2

Home Answers Viewqa SQL varchar & varchar2

QuestionAsk Questions?

samar

varchar & varchar2
1 Answer(s) 2 years and 7 months ago
Posted in : SQL

hii,

What is the difference between varchar & varchar2?

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.

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

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

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

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

hi - SQL
NOT NULL VARCHAR2(20) PHONENO NUMBER VILLAGE VARCHAR2(15

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

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

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

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

Ajax
NUMBER (10) NOT NULL, METER_NO VARCHAR2 (30) NOT NULL, PO_NO VARCHAR2 (30) NOT NULL, STORE_NAME VARCHAR2 (20), DELIVERY_DATE DATE, MAPPING_STATUS CHAR (1

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

Shifting txt file to database - Java Beginners
name varchar2 des varchar2 J_date timestamp b_date date Hi

Sequence generator problem - JDBC
VARCHAR2(20), MATTER VARCHAR2(150), MATTERFILE VARCHAR2(30), STATUS VARCHAR2(20

sqllllllll - Java Beginners
contain the fields name and data type using oracle NAMEOFCONT=varchar2 NUMOFCONLABENG=Number CONPERFORMDATE=Date CONPERTODATE=Date PONUM=VARCHAR2 VALUE=NUMBER ESI=VARCHAR2 EPF=VARCHAR2 This is the table name ConDetailspopup Qry

Database Design
` varchar(40) NOT NULL default '', `password` varchar(40) NOT NULL default...) NOT NULL auto_increment, `categoryname` varchar(60) default NULL, PRIMARY...` ( `id` int(11) NOT NULL auto_increment, `storename` varchar(50) NOT NULL

JSP - JSP-Servlet
` ( `days` varchar(255) default NULL, `1` varchar(255) default NULL, `2` varchar(255) default NULL, `3` varchar(255) default NULL, `4

project - JDBC
, `firstname` varchar(40) default NULL, `lastname` varchar(40) default NULL, `username` varchar(40) default NULL, `password` varchar(40

database connectivty
and designation are displayed how it is possible in jsp employee->(Ename varchar(30),Address varchar(256),Designation varchar(32),DateOfJoining date,ContactNumber numeric(12),PANNumbernumeric(15),Emp_Id varchar(50) primary key

database connectivity using jsp code
->(Ename varchar(30),Address varchar(256),Designation varchar(32),DateOfJoining date,ContactNumber numeric(12),PANNumbernumeric(15),Emp_Id varchar(50) primary key)this is employee table schema in mysql adduser->(Emp_ID varchar(50),Ename

Database Connectivity Withe Oracle
Integer Empname Varchar Emp_desig Varchar EmpJDate Varchar Emp_Salary Numeric

Jdbc connectivity by type 4 driver
=con.createStatement(); String createTable="create table test(name varchar2(20),fname varchar2(20))"; stmt.executeUpdate(createTable); System.out.println("Table

Query for generating Stock Report Using MVC architecture in j2ee
tables with data is: WATCHMASTER { watchid varchar(30), watchname varchar(20), Price varchar(20), QuantityAvailable varchar(30) } WATCHORDER { Orderid varchar(30), Quantity varchar(30), OrderDate DATE } someone told me here we used nested

Data base - JDBC
, street varchar2(20), city varchar2(15), state varchar2(10), pincode number

How to save array of UserType in Oracle using Hibernate.
ADDRESS_TY AS OBJECT ( plot number(4), street varchar2(20), city varchar2(20... Table EMPLOYEEARR(EMPID VARCHAR2(10),ADDRESSES ADDRESSTY_ARR

Database Design
) NOT NULL auto_increment, `language` varchar(15) NOT NULL, `question` varchar(800) NOT NULL, `ans1` varbinary(150) NOT NULL, `ans2` varchar(150) NOT NULL

displaying employee records and their images problem - JSP-Servlet
_name varchar(50); last_name varchar(50); department varchar(50); salary int; job_title varchar(50); Thanks in anticipation

alter data type
alter data type alter data type of subName column for subject table to varchar(40

how to create a table
how to create a table create table tablename (name varchar(10),name varchar(10)); You have specified name field twice, so error occurs. Use the following query: create table tablename (name varchar(10),address

upload csv to mysql db using jsp upload
have a table with 8 cloumns.(MDN--varchar(30),Otafdate date,crt varchar(30),dmdn varchar(30),dname text,rmdn varchar(30),rname text,cluster text) please help me

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics