Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: select * from v$version;
Latest Answer: Just type define on your sql prompt ..you will get required info.. ...
Answer posted by Scott on 2005-05-25 18:39:48: When you create a sequence with CYCLE option, you are saying that when the sequence reaches its MAXVALUE, it will start over at the MINVALUE. This is not
Latest Answer: when a sequence is created with CYCLE option, this mean that when a sequence reaches its MAXVALUE, it will start over at the MINVALUE. The CYCLE option is not wise for the primary key column.And when a sequence is created with NOCYCLE option, this ...
tnsnames.ora is used to connect to the remote db. To get the connection listener.ora should be configured at the server and it should be up and running.
Latest Answer: listener is used to get the client server communication. U can access ur server only if the listerner is ON ...
Answered by Scott on 2005-05-12 10:18:34: Constraints are found under the USER_CONSTRAINTS table.
Latest Answer: Correction to some answers aboveUser_Constraints is a view and not a table ...
Latest Answer: months_between(date1,date2) returns the number valueno other date functions return number value ...
Latest Answer: select * from employee where 1=(select count(*) from employee as e where employee.sal
Latest Answer: Select ROWNUM, col1, col2 from tablename; ...
Latest Answer: By utilizing savepoints, you are able to rollback to a given point in your processing. An example of this would be: ... COMMIT; INSERT UPDATE SAVEPOINT A DELETE UPDATE INSERT SAVEPOINT B INSERT INSERT DELETE SAVEPOINT ...
Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession
Latest Answer: DDL: Data Defintion LanguageDML: Data Manipulation LanguageTCL: Transaction Control LanguageDCL: Data Control Language ...
TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database
Latest Answer: Truncate is faster than delete as it does not generate rollback segment. ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 Next >>
Go Top
