how to create a new database using a query? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

how to create a new database using a query?

frizvifrizvi Posts: 14Member
Hello all,
How can I create a NEW DATABASE using a query in SQL (ORACLE)? Is there any query like CREATE DATABASE BLAH BLAH that can create a new DATABASE?

I will be thankful for your cooperation.

Faraz H.

Comments

  • infidelinfidel Posts: 2,900Member
    : Hello all,
    : How can I create a NEW DATABASE using a query in SQL (ORACLE)? Is there any query like CREATE DATABASE BLAH BLAH that can create a new DATABASE?

    Technically "CREATE DATABASE" is not an SQL statement, but yes, there is such a command in Oracle. You should search Google for: oracle "create database"

    It's not as simple as just saying "abracadabra" and a database appears. You have to specify things like tablespaces and control files and all that stuff, and you have to be user with the proper privileges as well.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

Sign In or Register to comment.