When I send e-mails using the package UTL_SMTP I am getting this error when executing the comand UTL_SMTP.MAIL:
Is there anyway to create a map data structure in开发者_JAVA百科 pl/sql.There is the PL/SQL associative array
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcann开发者_Python百科ot be reasonably answered in its current for
I have de-normalized table, something like CODES ID| VALUE 10| A,B,C 11| A,B 12| A,B,C,D,E,F 13| R,T,D,W,W,W,W,W,S,S
i have select like: select substr(account,1,4), currency, amount, module,count(*) quan, wm_concat(id) ids from all_transactions group by substr(account,1,4), currency, amount, module
Why does Oracle 10 R2 not allow use of notational parameters while calling functions in insert statements ?
I have a psql script that looks like this: -- first set of statements begin sql statement开发者_如何学C;
i got this Table: CREATE TABLE Test_Table ( old_val VARCHAR2(3), new_val VARCHAR2(3), Updflag NUMBER, WorkNo NUMBER);
I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details.
If I deploy N pl/sql packages to Oracle DB, can I make their compilation atomic i.e. the changes in these packages will be applied after the successful co开发者_StackOverflow中文版mpilation of all pac
加载中,请稍侯......