0
A trigger is a piece of code that will be fired on a given event. So for example if a piece of software deletes a record in the customer table, you might use a trigger to delete records from other tables that are associated with that customer.
Another example would be to write a log in a audit table, if someone changes the data in a table.
What else can I help you with?
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
Can you use SQL to pull data from Oracle?
yes.... example: select *from employee; dml command in sql language
Why do people actually use an Oracle SQL?
People actually use an Oracle SQL because the program helps to navigate and complete the task one has. This helps to get work done faster and more efficiently.
What has the author Jonathan Sayles written?
Jonathan Sayles has written: 'Oracle Sql*Plus for Application Developers' 'QMF' -- subject(s): Database management, IBM Database 2., QMF, SQL/DS 'SQL as a second language' 'SQL for dBASE IV' -- subject(s): DBase IV (Computer file), Database management, SQL (Computer program language) 'How to use Oracle SQL*Plus' -- subject(s): Oracle (Computer file), SQL (Computer program language)
What is the programming language does enovia use?
It's JAVA based on the front end with Html and Javascript for the web interface. The backend can be either Oracle or SQL Server 2005/2008 -- with SQL Server 2008 being be better performance over Oracle on the same hardware and lower cost.
What SQL based software programs are good for web hosting purposes?
There are many SQL based software programs one could use for web hosting. Some of these include SQL Server Express and Oracle. Both have received great reviews.
What are the responsibilities of a oracle certified professional java developer?
Oracle JDeveloper is the main development platform for Oracle's tools. The core IDE exposes an API that other teams in Oracle use to build extensions to JDeveloper. BPEL, Portal, BI and other components of the Oracle platform all build their design time tool on top of JDeveloper. The same IDE platform also serves as the basis of another Oracle product, SQL Developer, which is geared specifically at PL/SQL and database developers.
Difference between SQL plus and ISQL plus?
iSQL*Plus is a browser-based implementation of SQL*Plus. You can use it to connect to an Oracle database system over the Internet to perform the same tasks as those that are performed through the SQL*Plus command line. The iSQL*Plus implementation uses a Web browser, an Oracle HTTP Server with the iSQL*Plus Server, and an Oracle database.
What is the difference between sql and pl-sql?
Platform dependency-The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..Clustering technology-Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.Locking and concurrency -Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."File system-Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database.Replication -SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.Administration-SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.by....... Sankar
What is the difference between sql server and ms sql 2000 database?
SQL Server is most often referred to as Microsoft SQL Server, but there is also a Sybase SQL Server which was originally created on UNIX in 1987. MS sql 2000 database, or Microsoft SQL Server 2000 is a database server product. So, when you ask what is the difference, I do not see a difference, they are one in the same. Unless your question is asking for the difference between the Sybase version and Microsoft version, or you are wanting to compare different versions of Microsoft SQL Sever. In which case, I think your question must be more specific. arnel... SQL stands for (Structured Query Language). A SQL server can cover a host of products. Oracle is a SQL server however when speaking of Oracle people usually refer to it is Oracle. The server in fact is a SQL server. Microsoft SQL server is often simply referred to as SQL Server not because they 'own' the product or anything, just because of the popularity. I can draw a parallel for you. When you own a SeaDoo watercraft (as I do) people will refer to it as a jetski, same with a Kawasaki, Polaris, or any other brand. The fact is that this name (JetSki) is used interchangable however the Kawasaki Standup model watercraft is the only true 'jetski'. Anyway there are many 'flavors' of SQL server (MYSQL, Oracle, MS SQL Server, Postgress SQL, just to name a few. You can find more information about SQL server, its history and some additional 'flavors' at this link: http://en.wikipedia.org/wiki/SQL Hope that helps. Jwilliamsoh http://jwilliamsoh.spaces.live.com/
What are disadvantages of pl-sql?
Disadvantages of Oracle PLSQLIf you're just running Oracle databases, there are no major disadvantages to using PL/SQL as long as you're aware of its limitations.Proprietary to OraclePL/SQL is proprietary to Oracle which means if you were to change database vendors then you would have to re-write all your Oracle PL/SQL programs. Also if you use a mixture of databases or develop applications to run on different databases, you will either have to support lots of source code or write your applications in a database-neutral language like Java, VB or C and use the APIs to access the database.Poor I/O FeaturesThe other limitation of Oracle PL/SQL is that there is very little support for i/o either to read/write files or to read from or write to a user interface. The rationale behind this is that PLSQL is designed for manipulating information from the database and not for processing files or communicating with users. These operations are possible - they just require a little bit more effort!
A data warehouse uses which database?
A data warehouse typically uses a relational database optimized for analytical queries, such as Oracle, SQL Server, or Snowflake.
