What is an Oracle sequence?
Answer / nishi
A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the use of full option in exp command.
How to connect to the server with user account: sys?
how many columns can a plsql table have
how do get database name at sql prompt?
What privilege is needed for a user to create indexes in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
How do I reset a sequence in oracle?
What is format trigger?
What are the differences between primary key and unique key?
What is a subquery?
How many file formats are supported to export data?
how do u know the total no of rows in a table?