Search results for query: *

I have a query: select substr(ipis.contract,1,3) Company, ipis.contract, ip.type_designation, ipis.part_no, ipis.lot_batch_no, ipis.serial_no, ipis.qty_onhand, ipc.inventory_value Std_Cost, pol.buy_unit_price, (select currency_rate from currency_rate_tab cr where...

I have a long SQL query with a number of tables: select substr(ipis.contract,1,3) Company, ipis.contract, ip.type_designation, ipis.part_no, ipis.lot_batch_no, ipis.serial_no, ipis.qty_onhand, ipc.inventory_value Std_Cost, ith.dated Receipt_Date, pol.currency_type, pol.currency_code...

We have a table which holds exchange rates for various currencies: SQL> desc currency_rate_tab Name Null? Type ----------------------------------------- -------- ----------------- COMPANY NOT NULL VARCHAR2(20)...

I have 4 queries and need to amalgamate them to create one set of results. The first: select ipis.part_no, ipis.contract, ipis.lot_batch_no, ipis.serial_no, ipis.qty_onhand from ifsapp.inventory_part_in_stock_tab ipis where ipis.qty_onhand > 0 This is the primary query which should use...

Is this a restriction I can change (ie is 2048 set somewhere)? This is the script which has the grep: # Take input control file, # remove ALL lines upto (but not incl) 2nd STARTUP NO MOUNT, #/bin/ksh rm -f $2 startup_count=0 while read line do wrk1=`echo $line | grep ^STARTUP | cut -d" "...

Sometimes, for what ever reason, our application server (Windows 2000 server) just won't restart when asked to. I have ended a any app and obivous service, but it goes to teh shaded colour you'd expect but then after a while (or mouse click) returns as normal having NOT restarted. I beliebe...

I have to work out values to the nearest 16Mb. So a value of 2 = 16, value of 16 = 16, value of 17 = 32, etc. I think I need to round up value/16 regardless of the usual rule of .5 is up, otherwise down. Any ideas, please? Applications Support UK

I have a line of text on an input file as: db_files = 1024 control_files = ("/oracledata/IFSL/control01.ctl","/oracleindex/IFSL/control02.ctl","/oracledata/IFSL/control03.ctl") open_cursors = 100 I want to create, as a CSV file...

I have spent the past few weeks juggling my init.ora files to try to increase performance of our Oracle DB while leaving some memory for AIX to function! Based on the system spec: 8Gb memory 18Gb pagefile 4 ERP databases (1 live, 3 clones for testing) about 21 GB total datafile size each 1...

Having written a fairly large (for me!) VBA script inside Excel, I would like to print it. However, when I do, I lose the colours (even though printing to colour printer) which help readability. Is there a way around this, please? Applications Support UK

People are unable to log into our Oracle DB (no new processes it seems, until one signs out). There's a lot of defunct processes when I do ps g, results below. Is this the likely cause of the problems? Thanks PID TTY STAT TIME COMMAND 0 - A 17:34 swapper 1 -...

Having set up page setup detail, I'd like to emulate the File>Print action for the user, how can I do this, please? thanks Applications Support UK

Is it possible to use the value of a cell in Excel inside the header of the page setup, effectively providing the heading for the printed report? thanks Applications Support UK

Hi I am getting a run-time error '5' (Invalid procedure call or arguement) when trying to process the following: ActiveWorkbook.Protect password:=[WorksheetPass] WorkSheetPass is a named reference to a cell on sheet 2 (active is 1). It contains a value, such as "fred". The statement it...

I have a named cell and want to embed teh value inside the cell into a msgbox text. EG: dummy = MsgBox(Cells(ReportTitle).Value & vbCr & vbCr & HelpText, vbOKOnly, ReportTitle) Where ReportTitle is the named cell (and so is HelpText) Applications Support UK

Again, the Toad application reports "The database may have too many data files. A typical Oracle database should have just a few data files per tablespace. When a tablespace has lots of data files, it's often the case that the data file is being used as a generic container for too many unrelated...

An Oracle health check app (Toad) reports "The redo log buffer appears to be too large". "...On most systems, sizing the log buffer larger than 1 MB does not provide any performance benefit. Increasing the log buffer size does not have any negative implications on performance or recoverability...

My init.ora file has a LARGE_POOL_SIZE set to 1048576 but in OEM it reports it as 16M. Any idea how thi scan be so?! Applications Support UK

I have a table which has Item Number (ITEM) Site (SITE) and code (CODE) There can be more than one SITE per ITEM but only one CODE per ITEM/SITE. EG: ITEM SITE CODE 1 A 03 2 A 03 2 B 03 3 A 03 3 B 04 I want to report where the code is...

When I do a database copy, I clear up some data before letting folk in to the copy. Currently, I shutdown the destination, copy the datafiles over the existing ones, start (open) the database with a hacked control file. Then I run a script to update tables for various reasons. One update is...