How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?
Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.
CYCLE specifies that the sequence continues to generate values after reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its
Latest Answer: No cycle: after reaching to max val sequence will not give nextvalcycle after reaching to max val sequence will restart with startwith option vlues ...
To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.
Latest Answer: Advantages of view:1. Restricts the access to particular columns and rows of the base tables.2. Hide the data complexity.3. Can access the data for two different base tables with out performing a join.4. Can display the data in different form from the ...
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
Latest Answer: Take an example Table : Employee(id number primary key,name varchar2(20),departmentid number)If created view in such a fashion, it includes all Not Null attribues & it does not contains group by and disctinct key word, then view is updatableUpdatab;e/insertable ...
Latest Answer: Hi Guys,A subquery is a SELECT statement that is embedded in a clause of another SQL statement, Called the parent statement.The subquery (inner query) returns a value that is used by the parent statement. Using a nested subquery is equivalent to performing ...
Latest Answer: It is a subquery which is evaluated once for each row processed by parent statement. ...
Latest Answer: Non corelated subquery, where the subquery has been executed once for the entire parent statement. ...
Latest Answer: UNION : It is a set operator which retrives all the matching records from two different tables and eliminates the duplicate rows.OUTER JOIN: It is used to retrive lacking records from one table against the existing records from the other table. egselect ...
Latest Answer: With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor. the rows of a table can be fetched many timesSequence is repeated each time FETCH statement is issued ...
View page << Previous 9 10 11 12 [13] 14 Next >>
Go Top
