Compare sql and pl/sql, PL-SQL Programming

Question 1. Compare SQL and PL/SQL

Question 2. Write a database trigger to implement the following check condition

                         Given the following table

                         Empno       Empname       Joining Date

Every time the user enters the employee number in the above table, it should check that it is always >1 and <200

Question 3. Differentiate between shared pool and large pool of Oracle memory component

Question 4. Write about the following Oracle 9i objects

  • Logical Storage Structures
  • Database Blocks
  • Physical Storage Structures

Question 5. Write a query using oracle SQL to compute the number of months between September 29,1999 and August 17, 2003

Question 6. Write a select statement in oracle SQL that returns each instructors last name followed by a comma and a space, followed by instructor's first name all in single column in the result set

Posted Date: 11/6/2013 5:27:30 AM | Location : United States

Related Discussions:- Compare sql and pl/sql, Assignment Help, Ask Question on Compare sql and pl/sql, Get Answer, Expert's Help, Compare sql and pl/sql Discussions

Write discussion on Compare sql and pl/sql
Your posts are moderated
Related Questions
Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Indeterminacy in SQL Some SQL expressions are actually not function invocations at all in the mathematical sense, being indeterminate-invocations operating on identical input

Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN

Bulk Fetching The illustration below shows that you can bulk-fetch from a cursor into one or more collections: DECLARE TYPE NameTab IS TABLE OF emp.ename%TYPE; TYPE S

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Using RENAME in combination with JOIN - SQL Example gives pairs of ids of students having the same name, by joining two renamings of IS_CALLED. Example gives an equivalent ex

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Row Operators The Row operators return or reference the particular rows. ALL retains the duplicate rows in the result of a query or in an aggregate expression. The DISTINCT el

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can