Select Statement Displayed 100 Why Not 1 if i haven't Specify MinValue ?
By: Sugandh | 04 Mar 2015 6:05 pm | 608 times viewed | 0 Comments
I have a preocupation with this script test.
create sequence seq1
start with 100
increment by 10
select seq1.nextval from dual;
My select statement displayed 100 why not 1 if i haven't specify minvalue ?
No Comments Posted for this Article.
SAP and Lenovo tie up to Offer HANA in ChinaOne of the most eye catching deals for this year has been between SAP and Lenovo where the two majors have decided to tie up for developing the enterprise cloud offering in the China market. This is going to be quite an interesting and important partnership as far as SAP (Systems Applications...
SAP Assures Smooth Moves in GST for Indian CompaniesSAP Assures Customized Solutions for Enabling Indian Companies' Smooth Moves in GSTAn important subsidiary of SAP SE, also known as SAP India, has now reaffirmed its assurance to partners and customers in relation to the reforms linked with Goods and Service Tax (GST) in the nation. To this...
India Next in Line for SAP Via CloudWith a view of expanding its presence in the Subcontinent, Sap India is now eyeing the internet based ‘cloud’ for harnessing the advantages of software applications available in the same. It is also looking towards better and more profitable means of localizing its products to make inroads into...
What is SAP and What does SAP stand for?What is SAP?SAP the company was founded in Germany in 1972 by five ex-IBM engineers. In case you're ever asked, SAP stands for Systeme, Andwendungen, Produkte in der Datenverarbeitung which - translated to English - means Systems, Applications, Products in Data Processing.SAP is a INTEGRATED...
Earning Trends of SAP in the Stock MarketThe stock market is looking very unpredictable nowadays thanks to the fluctuating global economy, even good brands such as SAP are also not doing too good overall. SAP SE ADS is a well-known NYQ public traded firm and has a market cap of 90.33B. On an average the daily volume recorded in last three...
Avoid Hard Parsing for SELECT SQL Statement
I have the dynamic SQL statement which should be modified to Avoid Hard Parsing. For simple understanding, I have created a sample code which simulates my current situation of hard parsing. Goal...
How can I specify hints in SAP MaxDB?
Hello SAP Gurus, Can you guys tell me that how can I specify hints in SAP MaxDB as I am working on it and faced this query then need a valid and easy solution for this. If anyone is familiar...
Concerning About Oracle Cloud Control (OEM)
Hi All. I have a question concerning oracle Cloud Control (OEM). Here's the situation: I have a target database that I want to monitor with OEM. I want to use the logins and logouts of...
Oracle Query Performance
UPDATE F_ATTRIBUTES_PROCESSING FP SET TAC_003 = ( SELECT T.TAC_003 FROM (SELECT /*+ PARALLEL (D_ACCOUNT,8) */ D_ACCOUNT.ACCOUNT_NO, CASE WHEN T1.ACCOUNT_NO IS NULL AND D_ACCOUNT.STATUS !=10103 ...
Backup Database (Oracle 10g XE)
What I am dong is - set the ARCHIVLOG ON (which was off previously) from SQL COMMAND LINE Then I took the backup from - Backup Database. The result is - Doing online backup of the...
Oracle Database Deadlock
Hi, I am adding one update statement in the existing trigger on same table. So it gave an error mutating error. After that I added pragma autonomous transaction and after that it is throwing...
Oracle Character Set Convert
Background:now I have two oracle 11gR2 database in different machines,one is a product database,the characterset is ZHS16GBK ;the other one is a new database,the characterset is AL32UTF8?either the...