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

How To Calculate Expressions with SQL Statements
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics There is no special SQL statements to calculate expressions. But you can use the "SELECT expression FROM DUAL" statement return the calculated value of an expression. "DUAL" is a dummy table in the server. Th...
2016-11-09, 8358👍, 1💬

💬 2016-11-09 lux: good

SQL
How do you update 100 rows with single query with variable data populating each row ?
2014-09-19, 2556👍, 0💬

What happened to SQL*Menu?
What happened to SQL*Menu? From Forms V4.5, SQL*Menu is fully integrated into Oracle Forms. Application menus can be added to your application by creating Menu Modules (*.MMB) and generate it to Menu Module Executables (*.MMX).
2011-04-26, 4386👍, 0💬

Why doesn't my messages show on the screen?
Why doesn't my messages show on the screen? Regardless of whether you call the MESSAGE() built-in with ACKNOWLEDGE, NO_ACKNOWLEDGE, or with no mode specification at all, your message may or may not be displayed. This is because messages are displayed asynchronously. To display messages immediately, ...
2011-04-19, 4108👍, 0💬

Can one execute dynamic SQL from Forms?
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg: FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')'); Just note that FORMS_DDL will force an implicit COMMIT and may de-synchronize the Oracle Forms COMMIT mechanism.
2011-04-12, 6329👍, 0💬

Can one issue DDL statements from Forms?
Can one issue DDL statements from Forms? DDL (Data Definition Language) commands like CREATE, DROP and ALTER are not directly supported from Forms because your Forms are not suppose to manipulate the database structure. A statement like CREATE TABLE X (A DATE); will result in error: Encountered the ...
2011-04-05, 5084👍, 0💬

SQL Joins
What is the difference between Inner Join and Outer Join? 1. You use INNER JOIN to return all rows from both tables where there is a match. ie. in the resulting table all the rows and colums will have values. In OUTER JOIN the relulting table may have empty colums. Outer join may be either LEFT or R...
2008-09-25, 5652👍, 0💬

What Happens to Your Transactions When ERROR 1213 Occurred
What Happens to Your Transactions When ERROR 1213 Occurred? - MySQL FAQs - Transaction Management: Commit or Rollback If your transaction receives the "Deadlock found when trying to get lock" - ERROR 1213, MySQL server automatically terminates your transaction and rolls back your data changes of the...
2007-05-11, 6891👍, 0💬

How To Start a New Transaction Explicitly
How To Start a New Transaction Explicitly? - MySQL FAQs - Transaction Management: Commit or Rollback If you are confused on the implicit new transaction rules, you can always start a new transaction with the "START TRANSACTION" command to start a new transaction explicitly. "START TRANSACTION" comma...
2007-05-11, 5117👍, 0💬

How To Create a Table for Transaction Testing
How To Create a Table for Transaction Testing? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to learn transaction management, you should create a table with the InnoDB storage engine. The default storage engine MyISAM does not support the transaction concept. The tutorial exe...
2007-05-11, 5338👍, 0💬

What Happens to Your Transactions When ERROR 1205 Occurred
What Happens to Your Transactions When ERROR 1205 Occurred? - MySQL FAQs - Transaction Management: Commit or Rollback If your transaction receives the "Lock wait timeout exceeded" - ERROR 1205, MySQL server automatically terminates your transaction and rolls back your data changes of the entire tran...
2007-05-11, 5848👍, 0💬

What Happens to the Current Transaction If a DDL Statement Is Executed
What Happens to the Current Transaction If a DDL Statement Is Executed? - MySQL FAQs - Transaction Management: Commit or Rollback If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This ...
2007-05-11, 5723👍, 0💬

How To View and Change the Current Transaction Isolation Level
How To View and Change the Current Transaction Isolation Level? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to view or change the current transaction isolation level, you can use the following commands: SELECT @@TX_ISOLATION FROM DUAL; -- Viewing the current transaction iso...
2007-05-11, 5128👍, 0💬

How To Switch between Autocommit-On and Autocommit-Off Modes
How To Switch between Autocommit-On and Autocommit-Off Modes? - MySQL FAQs - Transaction Management: Commit or Rollback By default, your connection session will be in Autocommit-On mode, where every server executable statement will start a new transaction, and end the transaction when the execution ...
2007-05-11, 5145👍, 0💬

What Happens to the Current Transaction If a START TRANSACTION Is Executed
What Happens to the Current Transaction If a START TRANSACTION Is Executed? - MySQL FAQs - Transaction Management: Commit or Rollback If you are in a middle of a current transaction, and a START TRANSACTION command is executed, the current transaction will be committed and ended. All the database ch...
2007-05-11, 5205👍, 0💬

How Long a Transaction Will Wait for a Data Lock
How Long a Transaction Will Wait for a Data Lock? - MySQL FAQs - Transaction Management: Commit or Rollback If you issue a UPDATE or DELETE statement on a row that has an exclusive lock owned by another session, your statement will be blocked to wait for the other session to release the lock. But th...
2007-05-11, 5409👍, 0💬

How Does MySQL Handle Read Consistency
How Does MySQL Handle Read Consistency? - MySQL FAQs - Transaction Management: Commit or Rollback Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a par...
2007-05-11, 5447👍, 0💬

How To Commit the Current Transaction
How To Commit the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT command. It will make all the database ...
2007-05-11, 5024👍, 0💬

How To End the Current Transaction
How To End the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback There are several ways the current transaction can be ended implicitly or explicitly: In "Autocommit On" mode, a single-statement transaction will be ended implicitly when the execution of the statement end...
2007-05-11, 5212👍, 0💬

How To Experiment Data Locks
How To Experiment Data Locks? - MySQL FAQs - Transaction Management: Commit or Rollback If you want to have some experience with data locks, you can create two windows running two mysql transactions in two sessions. In session 1, you can run a UPDATE statement with REPEATABLE READ transaction isolat...
2007-05-11, 5206👍, 0💬

How To Find Out the Current Transaction Mode
How To Find Out the Current Transaction Mode? - MySQL FAQs - Transaction Management: Commit or Rollback If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise: >\mysql\bin\mysql -u dev...
2007-05-11, 5067👍, 0💬

How To Start a New Transaction
How To Start a New Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback MySQL server offers two modes to manage transactions: Autocommit On - Default mode. Can be started with "SET AUTOCOMMIT = 1" command. In this mode, every single SQL statement is a new transaction. All changes w...
2007-05-11, 5146👍, 0💬

What Happens to the Current Transaction If the Session Is Killed
What Happens to the Current Transaction If the Session Is Killed? - MySQL FAQs - Transaction Management: Commit or Rollback If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be remov...
2007-05-11, 5075👍, 0💬

How To Rollback the Current Transaction
How To Rollback the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROLLB...
2007-05-11, 5271👍, 0💬

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