Hello guys,
I need help about XMLForest,
here is my code :
create table example (
field1 varchar2(10),
field2 varchar2(10),
field3 varchar2(10));
insert into example values (null,null,null);
select xmlforest(lpad(nvl(field1,''),10,' ')||lpad(nvl(field2,''),10,' ') as "concatf1f2") from...
hello all,
how to make a process exactly run at 12am each day?
i used trunc(sysdate+1) at next_date
but .. when i look again.. the next_date was changed not to 12am :(..
thanks.
hello,
I have a dataFile at /data01/oradata/operational01.dbf
one day.. my oracle 9i was crash
then i install oracle 9i again..
can oracle know what information loaded at operational01.dbf? when i create a tablespace..for the new oracle.. like, the users, tablename and so on..
regards,
EkoW
Hello guys,
i'm new in C..
i have code like this :
#include <stdio.h>
#include <stdlib.h>
char *inputstr;
double atofret;
void main() {
inputstr="1234567890.1234";
atofret=atof(inputstr);
printf(" Converted to : %14.4f \n",atofret);
}
the result when i run the program is ...
Dear guys,
I have 1 oracle form the name is mainprogram.fmx, and i have 2 menus the name are mainmenu001.mmx and mainmenu002.mmx
when i push a push_button1 at forms, i want to change the menu to mainmenu001.mmx and when i push a push_button2 i want to change the menu to mainmenu002.mmx
what...
Dear All,
I have completed my Oracle Forms, Reports and Graphics program.
What i need is to deliver them to users.
does any body know how to make installer for them ?
Thanks.
regards,
Ekow
Mufasa,
I cannot change the generated file output from users,
and i cannot use the UTL_FILE because the DB server wont allow me to put something at their server..
so i have to parse the flatfile from client and send insert command.
i have done this using oracle forms TEXT_IO package,
but...
ok mustafa,
here is the sample of FLATFILE :
CODEBRID 982991002
CODENAME Avian
CODEPRICE 8000
CODESTOCK 312
CODEBRID 992995621
CODENAME Phone Book
CODEPRICE 20
CODESTOCK 120
The table structure :
ID Number(20) primary key,
NAME Varchar2(40),
PRICE$ Number(18,2),
STOCK Number(10)
so, i have...
thanks for the response guys...
the problem is, i can't access to the AIX server...
does any body have any solution,....
what i wanna do is ..just loading the flatfile to Oracle Server without SQL*Loader.
Regards,
Ekow
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.