Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    6

    Red face Unanswered: How to put both number and char values in column?

    Hi All,
    can anyone tell me plz how can i put both char and number values in one column.For example i am creating a table adding a column address and i want to put (123 alton street) into address column .How can i put this value?
    thanks in advance

  2. #2
    Join Date
    May 2006
    Posts
    42
    use varchar2

    e.g.

    create table sample
    (name varchar2(20),
    address varchar2(500)
    );

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink SQL training

    Quote Originally Posted by Ans12
    Hi All,
    can anyone tell me plz how can i put both char and number values in one column.For example i am creating a table adding a column address and i want to put (123 alton street) into address column .How can i put this value?
    thanks in advance
    Are you actually taking an SQL course or just experimenting with something you know nothing about?

    If you study an SQL tutorial you will get the answer to this question and many to other questions you may have.

    .
    Last edited by LKBrwn_DBA; 09-29-08 at 11:59.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    google is your friend.
    also, check the first sticky in this forum which was created just for you.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •