0
If one is wanting to create a table in Oracle one must use the "Create Table" statement. These tables are partially defined by the columns contained and the information in the column. One must first decide the proper column type and then these data types are used in the Create Table statement. One must be somewhat familiar with Oracle in order to create these tables and additional information can be found on the DBA-Oracle website.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is the differene between Oracle and database?
Oracle is a database. Oracle is a Relational Database Management System which is a specialized implementation of a database. It is designed to hold data that is related to one another and organized in the form of schemas and tables.
What is the difference between oracle and oracle?
Oracle is one of the popular database and DBA (DataBase Administrator) is the person who maintain the database (install oracle software, create,setup,maintain database)
What the maximum no of tables allowed in Oracle Database?
There is no practical limit.
How many tables can be joined together at a time in oracle?
254
Can we recall dropped tables from the oracle?
With Oracle 10g and above, yes, so long as they haven't been purged.
Is possible select 3 tables from oracle db at a time?
yes
What does SQL CREATE VIEW achieve?
SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.
How do you create software in oracle?
Install oracle. Design your database for your requirements. ex: If you want to implement a payroll soltion for a company then you you may have to consider creating tables like employee personal details, Employee employment data, employee pay details, Employee other benefits etc. Create tables, view, procedures etc. Populate tables with actual data. Develop User interface for your application. Provide roles and privileges to represent actual usage of the application. Ofcourse, you may have to create a login page etc. Connect your application to talk to database. Run your application and use the implemented functionality
Where are tables stored in oracle?
On disks in organizers called Tablespaces(TS). Tablespaces contain 1 or more data files. When you create a table, you tell it in the DDL what TS will house it. Gib
How do you use foreign key in to oracle?
the foreign key referential between two tables.
Why must create database in oracle?
gfhgfhgfhjgfjghk
How can we create directories in oracle database?
A directory for Oracle is created on the Unix OS. There is a "OFA" which is Oracle's standard directory structure. One of the reasons for adhering to this OFA is ease of administration. All Oracle databases are set up the same--therefore, a new DBA knows where to look for certain files in specific places. The Unix System Administration creates an Oracle DBA account. That account is allowed to create directories under an Oracle/database designated section only.
