creating database

Discussion in 'Databases' started by zaidrazzaq, Jun 17, 2010.

  1. #1
    plz i need a script in which by entrering data such as name num etc the information saves directly to server cmp,i knw this hapens through database plz if anybody has script help me
     
    zaidrazzaq, Jun 17, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    Nice joke. I am look for a script, which can generate active button "CASH", and money must get into my bank account after each click at this button :D

    For your task:
    1. Try to use any free CMS
    2. Try to engage a real programmer
     
    netload, Jun 17, 2010 IP
  3. rayqsl

    rayqsl Active Member

    Messages:
    91
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    53
    #3
    Let me know if you find this script.

    :)
     
    rayqsl, Jun 17, 2010 IP
  4. ashu_sood08

    ashu_sood08 Peon

    Messages:
    125
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    for creating the data base you have need to write the tables and then link these tables to thje site or the source from where you want to insert data in it
     
    ashu_sood08, Jun 21, 2010 IP
  5. ksrao

    ksrao Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi,
    See you can not enter data directly with out creating a DATABASE. You can create a Data Base in MS-Access, Sql Server , Oracle or any other RDBMS.
    The data base can be created in two ways
    1. One through GUI( Most commonly through Enterprise Manager) or
    With the help of Create Data Base Wizard.
    2. Second by creating a script and save that script as with .SQL extension as a script file and by running the script file
    or with the help of a CREATE DATABASE command.
    The moment you create the database there will be three types of files will b created
    (a) Control Files
    (b) Database Files
    (c) Log files will be created ( in case of Oracle in general that will be similar to all)

    See in Relation Data Bases every thing will be stored in terms of Tables only.
    Here tables are two types system and user tables what ever the data you want to store
    First you need to create tables and then enter the data with the help of insert command.

    Gather some basic Knowledge by going Through online Tests at wiziq dot com . or any other relevant books.

    Regards
    Kolla Sanjeeva Rao OCP Oracle 9i DBA
     
    ksrao, Jul 2, 2010 IP
  6. manimaran

    manimaran Peon

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Install Oracle database (you can download from Oracle website)
    Create new database (it will be created when you install oracle software for testing purpose)
    Login to oracle using sql*plus command prompt,
    sql> scott/tiger --syntax user/password@connection_string if you have only one database or set oracle home,sid then no need connection string
    sql>connected.

    then follow the below steps to create and insert data.

    sql> create table employee -------- create new table with name employee
    (empno number,
    emp_name varchar2(50),
    date_of_join date)
    ;
    sql>table created.
    sql>
    sql>insert into employee (empno,emp_name,date_of_join) ---------- insert record into this table
    values
    (1,'Manim','16-SEP-10');
    sql>inserted 1 record
    sql>
    sql> commit; -- save the changes
    sql>
    sql> select * from employee;
    sql>
    now you can see your data

    for some basic information you can try some tutorial
     
    manimaran, Sep 15, 2010 IP
  7. Rajeev123

    Rajeev123 Peon

    Messages:
    100
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Thanks for sharing manimaran for script..
     
    Rajeev123, Sep 21, 2010 IP
  8. manimaran

    manimaran Peon

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I'm happy to share my experience :)
     
    manimaran, Sep 22, 2010 IP