<< < 1 2 3 4 5 6   Sort: Rank

What Is Locking
What Is Locking? Locking are mechanisms intended to prevent destructive interaction between users accessing data. Locks are used to achieve.
2007-04-15, 4787👍, 0💬

What Is a Savepoint
What Is a Savepoint? Savepoint is a point within a particular transaction to which you may rollback without rolling back the entire transaction.
2007-04-15, 4826👍, 0💬

What Is Rollback
What Is Rollback? Rollback causes work in the current transaction to be undone.
2007-04-15, 5000👍, 0💬

What Is Posting
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the database but not committing these transactions to the database.
2007-04-15, 6556👍, 0💬

What Is Commit
What Is Commit? Commit is an event that attempts to make data in the database identical to the data in the form. It involves writing or posting data to the database and committing data to the database. Forms check the validity of the data in fields and records during a commit. Validity check are uni...
2007-04-15, 4818👍, 0💬

What Is a Transaction
What Is a Transaction? Transaction is defined as all changes made to the database between successive commits.
2007-04-15, 4741👍, 0💬

In What Order Different Parts of SQL Statements Are Executed
In What Order Different Parts of SQL Statements Are Executed? Where clause, Group By clause, Having clause, Order By clause and Select.
2007-04-15, 4810👍, 0💬

What Are Data Types Limitations
What Are Data Types Limitations? Max. columns in a table is 255. Max. Char size is 255, Long is 64K and Number is 38 digits. Cannot Query on a long column. Char, Varchar2 Max. size is 2000 and default is 1 byte. Number(p,s) p is precision range 1 to 38, s is scale -84 to 127. Long Character data of ...
2007-04-15, 4771👍, 0💬

What Are Indexes
What Are Indexes? Indexes are optional structures associated with tables used to speed query execution and/or guarantee uniqueness. Create an index if there are frequent retrieval of fewer than 10-15% of the rows in a large table and columns are referenced frequently in the WHERE clause. Implied tra...
2007-04-15, 4611👍, 0💬

What Are Synonyms
What Are Synonyms? Synonyms is the alias name for table, views, sequences and procedures and are created for reasons of Security and Convenience. Two levels are Public - created by DBA and accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifyin...
2007-04-15, 4654👍, 0💬

What Is a Sequences
What Is a Sequences? Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost.
2007-04-15, 4672👍, 0💬

That Is a Correlated Subquery
That Is a Correlated Subquery? Correlated Subquery is a subquery that is evaluated once for each row processed by the parent statement. Parent statement can be Select, Update or Delete. Use Correlated Subquery to answer multipart questions whose answer depends on the value in each row processed by p...
2007-04-15, 4712👍, 0💬

What Is a Join
What Is a Join? Join is the form of SELECT command that combines info from two or more tables. Types of Joins are Simple (Equijoin and Non-Equijoin), Outer and Self join. Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause. Non-Equijoin r...
2007-04-15, 4887👍, 0💬

What Are TTITLE and BTITLE? TTITLE and BTITLE are commands to control report headings & footers.
2007-04-15, 5186👍, 0💬

What Are Group Functions
What Are Group Functions? Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN and SUM.
2007-04-15, 4643👍, 0💬

What Are Character Functions
What Are Character Functions? Character Functions are INITCAP, UPPER, LOWER, SUBSTR and LENGTH. Additional functions are GREATEST and LEAST.
2007-04-15, 4743👍, 0💬

What Are Date Functions
What Are Date Functions? Date Functions are ADD_MONTHS, LAST_DAY, NEXT_DAY, MONTHS_BETWEEN and SYSDATE.
2007-04-15, 4787👍, 0💬

What Is NVL
What Is NVL? NVL is a function lets you substitute a value when a null value is encountered.
2007-04-15, 4679👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? SQL*Plus is an Oracle command line utility used for executing SQL and PL/SQL commands. The GUI version is called SQL Worksheet.
2007-04-15, 4802👍, 0💬

What Is SQL
What Is SQL? Structured Query Language (SQL) is the most popular computer language used to create, retrieve, update and delete data from relational database management systems. SQL has been standardized by both ANSI and ISO.
2007-04-15, 4820👍, 0💬

<< < 1 2 3 4 5 6   Sort: Rank