The PL/SQL script shown below is failing to execute at line # 20: declare type string_table is table of varchar(100);
I have a ta开发者_运维问答ble which contains multiple columns. Column 1Column 2Column 3 unique identifieralphanumerical valuenumerical value
When i am generating a table of values and writing the output as an email body using UTL_SMTP in pl-sql.
I need to create a report which retrieve expenses for the last 12 months. Depends on the day I execute my report the name of the columns of my report will change (for example if I execute the report i
I have procedure like this: Procedure(var1 IN VARCHAR2, var2 IN VARCHAR2 ... ) ---lines of code--- ---inside this procedure i want to d开发者_如何学编程o the below
simple question here, I am writing a function, but I was having trouble setting up my first if statement, my attempt is below, but I keep getting \"Expression can not be used as an assignment target\"
I would like to group a search result by days, but unfortun开发者_开发百科ately, the definition is not a day from midnight to midnight (00:00-24:00), but from 06:00 to 06:00.
I am looking for a way to automatically insert column na开发者_Go百科mes in TOAD for Oracle to make it easier for writing queries.
I have written this function in SQL and I can\'t figure out why but it keeps on returning an error in the exception section. I\'ve checked the syntax, got documented but I had no luck, will anyone ple
We ran into a particular issue with our Oracle table definition (DDL) and in one of our PL/SQL scripts.
加载中,请稍侯......