answersLogoWhite

0

Oracle Database

Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.

690 Questions

Do you need to register an account to use Oracle Support?

"To use Oracle Support and access the support services you have to register your account. If you are already a customer, you use your customer ID to create an account."

How are exceptions generated?

Exceptions are generated by the Java Virtual Machine during program execution. When the JVM comes across a piece of code that it cannot execute properly or a piece of code that will create issues when the JVM executes it will generate an exception. Ex: divide by 0 or trying to access a null variable etc

The language also has syntax that can catch and handle these situations. It is called the try - catch - finally construct.

Why do corporations use financial forecasts and financial projections?

Business entities need to plan for the future, must consider alternative management strategies and prepare capital and operating budgets, and must also consider alternative funding and cash budget possibilities

Where can one find information about Oracle Insert statements?

There are a number of websites one can check out for more information on Oracle Insert Statements. Some websites to check out include PSOUG, Tech on the Net and Docs Oracle.

Is Siebel a good customer management service for a company as important as Oracle?

Siebel is a good customer management service for a company as important as Oracle. As a matter of fact the Seibel CRM software is produced by the Oracle company.

What is macro call?

Nested macro calls refer to the macro calls within the macros. A macros is available within other macro definitions also. In the scenario when a macro call occurs, which contains another macro call, the macro processor generates the nested macro definition as text and places it on the input stack. The definition of the macro is then scanned and the macro processor complies it.

How can you restrict the values of data entered into a database?

By creating Data validation rules you should be able to restrict the values of data entered

How can a function return multiple values in plsql?

You cannot return multiple values from a function. A function returns one or no values. That is the definition of a function.

That said, you could have that one value be a pointer to a struct, or it could be a struct itself, and that struct could contain multiple values. You can also pass the function pointers to items in the caller's address space that the function could modify.

How to view the oracle view's content?

create table user_views_clob

(view_name VARCHAR2(32),

clob_text CLOB)

/

insert into user_views_clob

select view_name, to_lob(text) from user_views

/

and do the search like

select * from user_views_clob where upper(clob_text) like upper('%hello_world%');

replace hello_world with your text.

Why were the words of the oracles difficult to interpret?

because it was hard to understand in a different language

What does SAP ISretail Stands for?

SAP/IS-Retail Stands for SAP Industry Specific or Industry Solutions for Retail

Why is Oracle 10g named so?

In Oracle 10g, 'g' stands for grid computing. For more details about Oracle 10g and overall Oracle DB please refer the following link:

http://en.wikipedia.org/wiki/Oracle_Database

What is oracle bi presentation catalog?

This is a presentation area in the OBIEE software. In this catalog you can alter system names to user friendly names for your end reporting.

How do you find oracle home name in oracle 11g?

In most cases you can from the command prompt you can type in env. This will return the environment variables and identify the path for $ORACLE_HOME.

What is the difference between Oracle 10i and Oracle 10g?

Oracle 8i and 9i were databases with 'i' referring to the Internet. For version 10 onwards, Oracle named the database as 10g, 'g' referring to the grid. 10i and 11i are ERP systems, nothing to do with the database.

What is the difference between logical and physical data independence?

The logical data independence is the ability to modify a logical schema without making external view or application program change.

The physical data independence is the ability to modify a physical schema without making external view or application prrogram change.

What is the Oracle PeopleSoft software used for?

Oracle PeopleSoft software are designed to address the most complex business requirements. They provide comprehensive business and industry solutions including: human capital management, financial management, supplier relationship management, etc. Their software enables organisations to increase productivity, accelerate business performance and provide lower cost of ownership.

What is the purpose of Oracle Retail applications?

The purpose of Oracle Retail applications is used for promotion and optimization within a business. It can also be used to manage a store supply chain effectively.

Where can i register for oracle certification exam in coimbatore?

To register for ORacle certification, you have to purchase exam voucher from any authorized Pearson Vue or NIIT Pearson Vue Center. In fact you can give exam in any center from where you'll purchase the exam voucher.

Oracle exam voucher will costr you between $95 and $125, i.e. Rs. 4375 and Rs.6250.

Checkout training.com for Oracle DBA Certfication training with expert-authored courseware and brainbench mock exams..