Create function in SQL

I need a simple SQL program demonstrating the use of CREATE FUNCTION command in SQL. A create table can be used to generate a simple record of items such as name, title, age. The Create Function command will be used to retrieve one specific value. The program should demonstrate and show how you can pass a variable in and outp ...continues

Oracle 10g

What advantages (if any) are there to using data files over a database system?

Oracle 10g

Which of the data dictionary views are most useful, and why?

Excel Formulas

I need help with the attached 3 sheets. The formula matching I need explained what and why would match each letter to each statement but does not have to be answered, I am more concerned with the formula sheets. The other 2 sheets are formula related and I need those explained as to which formula to use and how.

Relational schema diagram (ID all dependencies to include transitive)

Using the STUDENT table structure attached, write the relational schema and draw its diagram. Identify all dependencies (including all transitive dependencies)

Which one is more feasable?

As we start designing a database for implementation should we use the latest and greatest technology? Does the user need a flat-file or object-oriented database? Give an example of each and how it would apply to the basic database designer goo roo.

Database management systems

Describe database management systems and what they are used for. (Consider Microsoft Access, SQL Server, Oracle, DB2, etc.)

Differences between row-level, column-level, and table-level locking?

Can anyone tell me the differences between row-level, column-level, and table-level locking? Why would you need to use them?

DBMS Concepts and Business Rule Identification from ER Diagrams

DBMS Concepts and Business Rule Identification from ER Diagrams. See attached file for full problem description.

Does Oracle not allow the deletion of fields and if so, how do you handle this?

Question: Does this statement still hold true? Does Oracle not allow the deletion of fields and if so, how do you handle this? If so why? Seems like not having this ability would make modifications of a database more challenging. Also... the same question, "For example, some systems, including Oracle, do not allow you to r ...continues