compiler hints is a assurance to detecter of the result path.it creates a role of identifier to check the program when the program is executing.
What is mandatory process in oracle 10 g?
There are five mandatory processes in oracle 10g.
1.PMON
2.SMON
3.DBWR
4.CKPT
5.LGWR
Archiever process is mandatory if your database is in ARCHIEVED log mode.
What is the difference between query and script in sql?
A query looks up existing information in a database.
A script could do that too, as well as also change what's in the database, creating and loading new tables, deleting or updating existing records or changing any other object in the database.
Bones are made of cartilage that fuse into bones throughout childhood. Bones contain yellow marrow, phophorus, and other minerals in small amounts.
Why did Google change their database from Oracle to MySQL?
Google don't use Oracle or MySQL, they use their own database software known as Bigtable.
What is the difference between Cisco networking and Oracle database administration?
Night and day. Apples and oranges.
The skills aren't equivalent, transferable or related.
What is oracle software structures?
when we install d oracle software, on oracle directory structure is created to store the executables , shared libraries , configuration files , trace files , and so on both server and client software is stored in the same directory. Oracle is installed on the server using on operating system account created specially for the task oracle has a directory structure.
Who invented the first database?
Dr. Edgar Frank Codd invented the first database in the year 1996. His birthplace is Portland and his birth year is 1923.
What type of service does Oracle Security offer?
Oracle Security Service is an online service provided by Oracle to monitor your entire cloud network. If it finds a problem it will notify you and fix the problem.
How can you transfer data from Oracle to Microsoft Word?
I just looked at Word--I did not see an import comma delimited feature. So, I don't think you could do a direct transfer from Oracle to Word. Now, if you wanted data from a select statement into a text file, try this:
1. right click
2. log incoming to file
3. name file
4. select data and everthing that goes to the screen will be captured into the log file.
5. right click, turn log file off.
6. Find file via windows explorer.
When does the Oracle Open World take place in 2013?
The 2013 Oracle Open World will take place in San Fransisco, California and will start on September 22. It will run from the 22nd until the 26th of the month.
It is an analytical engine, used for forecasting the anaytical report for business.
Demantra -Its a Process from "Deman"d Management to "Tra"de Planning
Includes 4 stages/modules :
1. Demand Management
2. Advanced Trade Planning and Demand Management
3. Sales and Operation Planning
4. Predictive Trade Planning
Thanks,
Naveen
What is the features homogeneous database?
Its primary feature would be setting up a database link between Oracle and another database such as SQL Server. Homogeneous database links are set up as new listeners which can be referred to in your TNSnames.
Package variable
A multimedia database is a database that hosts one or more primary media file types such as .txt (documents), .jpg (images), .swf (videos), .mp3 (audio), etc. And loosely fall into three main categories:
Static media (time-independent, i.e. images and handwriting)
Dynamic media (time-dependent, i.e. video and sound bytes)
Dimensional media
"an oracle"An oracle is a person, such as priestess, through whom a deity is held to respond when consulted. An oracle is a being of great wisdom and insight. One from whom one would seek advice. A special priest guided by the Gods.
"Oracle"
Oracle Application Express, or Oracle Apex is an application one can use on the Oracle platform. It enables users to build web databases for use. There is no cost associated with the Oracle Apex.
create a table with the name 'team'
CREATE TABLE team(team_no NUMBER(4),team_name VARCHAR2(20),team_loose NUMBER(3),team_own NUMBER(3));
insert values into a table team:
INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'royal',3,2);
INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'daredevils',2,6);
INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'chennai',4,2);
INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'rajsthan',2,4);
INSERT INTO team(team_no,team_name,team_loose,team_own)VALUES(111,'kerala',5,8);
SELECT team_name from team WHERE team_own IN(2,4,6,8);
Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.
He is the co-founder, and chief exec. of Oracle Corporation.
What are the Merits and Demerits of Tally over Oracle Application?
what are the merits and demerits of tally?
What is difference between alter and modify on oracle?
MODIFY is a clause used within an ALTER statement, such as ALTER TABLE, ALTER INDEX or ALTER MATERIALIZED VIEW, etc. That is, MODIFY isn't a command by itself.
For example, you might change the length of a text column in a table with the following:
ALTER TABLE employee MODIFY (email_address VARCHAR(132));
What is the website Oracle Wiki for?
The website Oracle Wiki is designed for bussiness users or the development community to build rich web applications. Also to help the development with bussinesses.
Draw Entity Relationship diagram for hotel management system?
You can use a template and customize it to fit your personal hotel management system, or you can do one from scratch. There is no wrong or right answer.
ALTER TABLE table_name MODIFY (column_name VARCHAR2(20));
Where might one go online to find information about Oracle Licensing?
You can visit the official Oracle website to locate options and packages available for Oracle licensing. You can also contact Oracle at 1-800-633-0738.