I have PL/SQL procedures which are running well on Oracle 8 /Unix Aix4.
It is now impossible to create/compile them on Oralce 9/Aix 5 because some
lines (list of columns)od code are too long.
Have you ever had this trouble?
Is there parameters to change to increase the line length?
Thanks for...
""
"Is it possible to create a "dynamic list of values" in a prompt whose its list depends on the selection of a previous list of values.
Per exemple I have 2 prompts : Country and town.
The user selects a value un "Country" (France per exemple) and when he...
Hello !
IS it Possible the to change the Character Set After Database Creation.
I have been created my instance with the character set = WE8ISO8859P1 and now i want to use cyrilic character.
I need to change the character set to EE8ISO8859P2.
Do you think is it possible with recreating the...
Hi!
Is it possible to disable the debug panel or debug button when there is an error on the report with the VBA.
I just want to see the error code and message but i don't want the users see the VBA code.
thanks for your help!
Erwan
Hi,
I want to link two reports.
If the user click onto a value of the first one, i would like to open a predifined report using this value as prompt for the second one.
I try to create an objet under designer using html reference. the parsing is OK, but when i want to create a report using...
I have a big table ( more than 50 0000 lignes and 185 rows). This table is store daily and i have to put then in our datawarehouse. I don't know which modele is the best way.
- A star schema, with 1 table of facts and 8 tables od dimensions.
- or 1 table od facts and 1 other table with all the...
In sql, i want to get only 10 gretest values on a table .
I try with ROWNUM with " where rownum > count(*) -10 but the "order by" is made after the rownum and the result is false.
how can i do that.
thank you!
In sql, i want to get only 10 gretest values on a table .
I try with ROWNUM with " where rownum > count(*) -10 but the "order by" is made after the rownum and the result is false.
how can i do that.
thank you!
In sql, i want to get only 10 gretest values on a table .
I try with ROWNUM with " where rownum > count(*) -10 but the "order by" is made after the rownum and the result is false.
how can i do that.
thank you!
In sql, i want to get only 10 gretest values on a table .
I try with ROWNUM with " where rownum > count(*) -10 but the "order by" is made after the rownum and the result is false.
how can i do that.
thank you!
erwan.peccaud@bnpparibas.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.