BLOB field in group by

,OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF , det.lot_number , det.sublot_number , det.preferred_grade , det.shipping_instructions , det.packing_instructions ORDER BY p_order_by -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network

Help Please

If I have a table that has a fields of type long, how can I move the data to a varchar2(300)? Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Extracting information from a table on another database

Hi Gurus, Can anyone tell me how to extract information from a table in another database. Please provide the syntax for it. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Documentation for pricing database

Hi Gurus, Can anyone suggest some kind of documentation I can use to develop a pricing/costing database in Oracle? I have been looking around for a reference manula but they are quite general. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark

RE: get yesterdays date

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu

GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE

, 1, 250)) but still gave me the same result. Tried TO_VARCHAR2 but to no avail. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Query on Month-to-date and Year_to_date

1500.00 124,445.57 Does anyone know what reference material I should purchase for oracle reports? Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services

Export from sql plus

Is it possible to export the whole content of a table to a file. If is it , what is the command to do this? Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

HELP !!! scrpt works with sql plus but not in a procedure

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Registering custom reports

I have a custom report that I want to register in Oracle Application 11i. Does anyone know how to do this or probably suggest a good reference . Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network

Oracle reports

1500.00 124,445.57 Does anyone know what reference material I should purchase for oracle reports? Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services

RE: Creating reports

') GROUP BY AR.RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID ORDER BY AR.RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID; Thanks in advace for the help. Mark Liggayu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network

Creating reports

BY AR.RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID; Thanks in advace for the help. Mark Liggayu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

creating and dropping tables in plsql

section and it said that you cannot use DDL in a plsql statement. Is that right, and if it is , is there a way around it? If I could do it in a plsql statement how should I do it? thanks, mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET

Autologout of idle users

What commant should I use to automatically logout uses in oracle who has been idle for more than 30 minutes? We have UNIX as an OS. Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services