Results 1 to 2 of 2

Thread: Sockets and Sql

  1. #1
    Expert Member
    Join Date
    Oct 2006
    Answers
    209

    Sockets and Sql

    Which TCP/IP socket is used for SQL.2.What is a maximum size of ROW3.How many columns we can create in a table.4.Which tool is used for Oracle and PL/SQL.


    Note : This is the question asked by a visitor Nishanth. I am posting this in proper forum.


  2. #2
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Sockets and Sql

    Maximum Row Size
    For Oracle8, and later releases, the maximum row size is 4,000GB (or 4GB per LOB, 1,000 LOBs per table) or just take the maximum varchar2 size (4000) with maximum columns 1000, it will be 4000x1000=4,000,000 bytes of structured data.

    For Oracle7 Release 7.x, the limit is 254 columns per table in which the varchar2 maximum is 2000 bytes, so that's about a total of 508,000 bytes of structured data.

    Maximum Columns in a table
    The maximum columns allowed for Oracle 7 is 254.
    Then there was an increase from 254 to 1000 columns when Oracle release 8.0 was introduced.

    Oracle & PL/SQL Tool
    My personal opinion for the best tool for Oracle is TOAD.
    PL/SQL Developer Tool also can be used for SQL & PL/SQL.

    Regarding the TCP/IP socket, im not very sure abt that. I dont want to give information with doubts.
    As far as i know, the default port number is 1521 for Oracle & 1433 for SQL Server.

    *** Mangai Varma ***


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact