Why not have comment on sequnce?

BEDE

For easier documenting the database. Like we have coment on table, wouldn't it be good to have comment on sequence?

Like:

comment on sequence x_sequence is 'used for x_table.id column'

;

I know that we may have comment on x_table.id is 'primary key populated using sequence' and that in 12c there is the possibility to associate a sequence to a given column. But what if, for some reason, a given sequence is used in different ways that are would not be so straightforward?

GregV

Thsi idea can be included in the one already suggested:

Generally I think it would good to allow for comments on all objects.

Gerald Venzl-Oracle

I agree, this should be treated as a duplicate under the more generic idea

User_PN1D5

Hello

  GregV, My name is Daniel Ruperto Student from UPPR (Polytechnic University of Puerto Rico) I'm working on the Intern Project in one local Company where I need to fix performance issues with Oracle Query. The program is made in C# (Web method) where uses a query to insert each parameter in the oracle database by "for loop". My project is to search for an alternative to collect all parameters and inert only with one call.

Oracle Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Solaris: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

Logic is something like:

***  public const string TableInsert  = @Insert into MyTable values (:param0,:param1,:param2,:param3,:param4,:param5,:param6,:param7); my problem is I'm using a for loop to pass different parameter to insert few rows depend of Data.counts. using a For Loop. my problem is performance is struggle by oracle call in each insert. It is possible to insert a list of each parameter? something like IN statement?

I try Something like:  Insert into MyTable values IN (List0,List1,List2,List3,List4,List5,List6,List7)" but statement is wrong. Please any suggestions.

FYI

Actually parameters are something like:

List 1 = ABC,ABC1,ABC2,ABC3...N   Where n = Data.counts

List 2 = ABC,ABC1,ABC2,ABC3...N

List 3 = ABC,ABC1,ABC2,ABC3...N

List 4 = ABC,ABC1,ABC2,ABC3...N

.

.

List 8

Thanks

Sven W.

Hello

  GregV, My name is Daniel Ruperto Student from UPPR (Polytechnic University of Puerto Rico) I'm working on the Intern Project in one local Company where I need to fix performance issues with Oracle Query. The program is made in C# (Web method) where uses a query to insert each parameter in the oracle database by "for loop". My project is to search for an alternative to collect all parameters and inert only with one call.

Oracle Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Solaris: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

Logic is something like:

***  public const string TableInsert  = @Insert into MyTable values (:param0,:param1,:param2,:param3,:param4,:param5,:param6,:param7); my problem is I'm using a for loop to pass different parameter to insert few rows depend of Data.counts. using a For Loop. my problem is performance is struggle by oracle call in each insert. It is possible to insert a list of each parameter? something like IN statement?

I try Something like:  Insert into MyTable values IN (List0,List1,List2,List3,List4,List5,List6,List7)" but statement is wrong. Please any suggestions.

FYI

Actually parameters are something like:

List 1 = ABC,ABC1,ABC2,ABC3...N   Where n = Data.counts

List 2 = ABC,ABC1,ABC2,ABC3...N

List 3 = ABC,ABC1,ABC2,ABC3...N

List 4 = ABC,ABC1,ABC2,ABC3...N

.

.

List 8

Thanks

--- duplicate post because of forum glitches deleted ---

Sven W.

Hello

  GregV, My name is Daniel Ruperto Student from UPPR (Polytechnic University of Puerto Rico) I'm working on the Intern Project in one local Company where I need to fix performance issues with Oracle Query. The program is made in C# (Web method) where uses a query to insert each parameter in the oracle database by "for loop". My project is to search for an alternative to collect all parameters and inert only with one call.

Oracle Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Solaris: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

Logic is something like:

***  public const string TableInsert  = @Insert into MyTable values (:param0,:param1,:param2,:param3,:param4,:param5,:param6,:param7); my problem is I'm using a for loop to pass different parameter to insert few rows depend of Data.counts. using a For Loop. my problem is performance is struggle by oracle call in each insert. It is possible to insert a list of each parameter? something like IN statement?

I try Something like:  Insert into MyTable values IN (List0,List1,List2,List3,List4,List5,List6,List7)" but statement is wrong. Please any suggestions.

FYI

Actually parameters are something like:

List 1 = ABC,ABC1,ABC2,ABC3...N   Where n = Data.counts

List 2 = ABC,ABC1,ABC2,ABC3...N

List 3 = ABC,ABC1,ABC2,ABC3...N

List 4 = ABC,ABC1,ABC2,ABC3...N

.

.

List 8

Thanks

Hello 4190280,

Welcome to the forum.  Please understand that your post is totally off topic.
This is the space where suggestions for enhancements to the oracle database are made. The "ideas space".
It is the thread where one forum member suggested to add comments to sequences.

Nothing your post indicates that you want to contribute to this idea.

If you seek help, then please consider to repeat this question inside the plsql space here: I'm not sure if that is the best lace however. You can open a new discussion there under Menu point "Actions"/"Discussion" (Way to hard to find I believe).

Btw. what you want can be done using FORALL in plsql. For information about array binds in C#, you should go and ask inside some C# forum.

Regards

Sven

User_PN1D5

Hello 4190280,

Welcome to the forum.  Please understand that your post is totally off topic.
This is the space where suggestions for enhancements to the oracle database are made. The "ideas space".
It is the thread where one forum member suggested to add comments to sequences.

Nothing your post indicates that you want to contribute to this idea.

If you seek help, then please consider to repeat this question inside the plsql space here: I'm not sure if that is the best lace however. You can open a new discussion there under Menu point "Actions"/"Discussion" (Way to hard to find I believe).

Btw. what you want can be done using FORALL in plsql. For information about array binds in C#, you should go and ask inside some C# forum.

Regards

Sven

ok

Thanks for details