Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 136

Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.

1
vote
As you are not showing your script to us, lets work the other way around. create a table in your database Create table Test_call_count ( count number(10) ); insert into Test_call_count values (0); …
answered Feb 16 '11 by bernd_k
4
votes
Why not just create a sequence? CREATE SEQUENCE TEMP_YEAR_sEQUENCE START WITH 2008; SELECT TEMP_YEAR_sEQUENCE.NEXTVAL FROM DUAL; .... DROP SEQUENCE TEMP_YEAR_SEQUENCE; EDIT: For small ranges o …
answered Jun 3 '11 by bernd_k
4
votes
3answers
I have a problem with an update statement, that I developed under 11g, when running under 10g. I reduced the problem to: Create table test ( col1 number(10) ); insert into test values (1); upda …
asked Mar 30 '11 by bernd_k
2
votes
I found the following work around: update test set col1 = NVL((select 1 from DUAL ), NULL) + 1;
answered Mar 31 '11 by bernd_k
0
votes
It is OK to use Execute immediate here. You can shorten the conditional creation to: BEGIN EXECUTE IMMEDIATE 'CREATE SEQUENCE USER_DEVICE_MAP_BACKUP_SEQ START WITH 1 INCREMENT BY 1'; exception …
answered Dec 19 '11 by bernd_k