Answer / sachin

Hey Guies,
Please do not put a wrong answer.. Since other seeking for
info getting the wrong answer.

Answer / guest

Use DBCA

Answer / pradeep

Create database database_name;

Answer / nathahar anees

MANUAL CREATION:
CREATE APROPRIATE FOLDERS IN THE CORRESPONDING LOCATION AND
CREATE PFILE..
COME TO COMMAND PROMPT CREATE NEW SID USING ORANEW COMMAND
AND START INSTANCE IN NOMOUNT STAGAGE AND CREATE A DATABASE
COMMAND FOR DATABASE CREATION.

sql :> CREATE DATABASE <DATABASE NAME> DATAFILE....

AND RUN CATALOG AND CATPROC SCRIPTS

Answer / dipen

lRetVal varchar2(50);

Answer / shrikant jadhav

create table emp(id number(12),name varchar(12));

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers  

How to define a data field as not null?

0 Answers  

How to sort the query output in oracle?

0 Answers  

primary key is foreign key for the same table?

2 Answers   Oracle,

Explain what does a control file contain?

0 Answers  

What are the differences between date and timestamp in oracle?

0 Answers  

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

0 Answers  

Explain the use of Merge statement in oracle 11g

0 Answers   Infosys,

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 Answers  

Why should I use oracle database?

0 Answers