What is the constructing question phrase in Turkish ?
Constructing question phrase in Turkish is very simple and straightforward. You just add "değil mi?" at the end regardless of the sentence. Examples; You are home, aren't you? --> Evdesin, değil mi? He did his homework, didn't he? --> Ödevini yaptın, değil mi? John will come today, won't he? --> John bugün gelecek, değil mi?
What are the advantages of using a stored procedure?
Stored Procedures are precompiled and stored in the database. This enables the database to execute the queries much faster. Since many SQL queries can be included in a stored procedure, round trip time to execute multiple queries from source code to database and back is avoided.
What is System Change Number (SCN) in Oracle Database?
- SCN is a unique number that Oracle generates for every committed transaction - It is recorded for every database change in the redo log entry - SCN is also generated for every checkpoint (CKPT) event occurred - It is an ever increasing number which is updated for every 3 seconds - You can get the SCN number by querying "select SCN from v$database" from SQLPLUS.