0
Oracle Database
Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.
690 Questions
Where can one find out if Oracle has had an update?
Oracle updates can be viewed on their company website or if you just visit their website you can find the update notes. However right before you update the oracle program will usually show you the patch notes.
Why are certain functional dependencies called trivial functional dependencies?
A functional Dependency_theory_(database_theory)(FD) is a constraint between two sets of attributes in a Relational_modelfrom a Database
Given a relation R, a set of Attribute_(computing) X in R is said to functionally determineanother attribute Y, also in R, (written X → Y) if and only if each X value is associated with precisely one Y value. Customarily we call X the determinant set and Y the dependent attribute. Thus, given a Tupleand the values of the attributes in X, one can determine the corresponding value of the Y attribute. For the purposes of simplicity, given that X and Y are sets of attributes in R, X → Y denotes that X functionally determines each of the members of Y - in this case Yis known as the dependent set. Thus, a Candidate_keyis a minimal set of attributes that functionally determine all of the attributes in a relation.(Note: the "function" being discussed in "functional dependency" is the function of Identification_(information).)
A functional dependency FD: X → Y is called trivial if Y is a Subsetof X.
How do you find out the schema name of a table in SQL?
Schema name or database qualifier indicates the ownership of the object. Schema name for a database object can be found using below sql -
SELECT owner FROM all_objects WHERE object_name = 'tablename';
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."
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.
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
