Search results for query: *

All, So we have the latest Oracle designer / Dev 200K toolkit, we are using it to store and generate the applications Tables / indexes etc. scripts and the guy that looked after it has left with no handover. I need to get to grips with this side of it first, currently we have little other use...

Hi, I have a problem where I need to remove a large amount of duplicate records from a large table. There are around 300 - 400K duplicate records in the table. The table containts about twice that in terms of total records (800K) Not all records are duplicated and some are duplicated many...

Thanks for the solution, it's working a treat, I'll have to remember these Date settings, they're something of a gotcha...

why is Oracle NEVER simple... I have to get the date back for Monday, regardless of which Country it is running in and therefore independent of any NLS Settings, which if I've read the obove correctly means sems suggestion is never going to work as the below shows. SQL> ALTER SESSION SET...

OK, now I'm confused... select trunc(sysdate,'D'), trunc(sysdate,'WW') from dual returns the same results, under what conditions would they differ? Thnaks in advance, Mike.

I've gone with sem's in the end. Just incase anywone has a better way of doing it here is the problem and what I coded... I had to find records that were due in the current week, the week is defined as running from midnight Monday to end of Sunday, the table has a column called due_on which is...

Hi Everyone, I need to work out the date for the start of the current week, assuming that Monday is the first day, so If I ran the query today (19th) it would return today, but If I ran it yesterday (18th) it would return the 12th. How can I do this in SQL?? Cheers, Mike.

I need to "refresh" or more accurately fix alot of constraints on a number of tables. All of these tables have some constraints but they are all incorrect and they contain data, and some of them might even be on customer sites *ahem* So I'm not in a position to do anything export /...

Does anyone have a script they wouldn't mind posting that given a table would produce the text necessary to create all the constraints on that table? Cheers, Mike.

?? I was always under the understanding that if you set the reports output to printer (rather than previewer etc.) then the PC that was running it would send it to it's default printer? What version of reports are you using?

I'd go with either the Oracle Press series or the O-Reilly ones, I've used the Oreilly my self, but know people who have the other and lie them too. Both should be available in a big Waterstones, or you could atleast order them from there. Happy reading, Mike.

8.0.5 eh? That a real shame, If you could get the server upgrades to 8.1.6 then Oracle supplies a package called dbms_smtp that would fill your requirements very nicely. But you on 8.0.5. Many moons ago before Oracle grasped that sending emails from the DB would be useful I implemented the...

On a rather pedantic note, I like using dbms_utility.exec_ddl_statement kinda self documents what you are doing...

Have you emailed Quest about your concerns? If enough people who use Toad / SQL Navigator ask for it to be ported it may well be, It's written in Delphi which can be ported now to Kylix which runs on Linux. So it not as if they would have to re-write the product.

I'm thinking that this is the PL/SQL engine throwing up an error because you are trying to execute an SQL Plus command. Trying wrapping the statements in an execute immidiate statement which should solve your problem... execute_immidiate 'CREATE OR REPLACE VIEW DB2_FDBTAB ( BID, TBCODE)...

I'm proably be picky but if you don;t want to manipulate the data within the DB (Just store it) you might be better of with a BFile, this is like a LOB but is not stored in the DB, it would reduce the size of the DB considerably if the files are large...

Can you not do.. using tablespace <tablespace_name> at the end of the statement?

I was looking into this, from a slightly different angle, I wanted to be able to do... SELECT .... FROM pl/sql WHERE.... Order BY ... and well it is possible but a bit of a bummer. how do you access Oracle stuff from Crystal? Can you base a report on an array or would it have to be a query??

If your looking at doing this alot it might be worth investing in a 3rd party tool, I'm currently getting to grips with the PL/SQL Profiler in TOAD and have found it extremely useful, You can run a top level PL/SQL Block and then see where the execution time was spent, what was executed the...

I was always under the impression that Oracle tidied up any extra processes correctly? Can you give an example of the alter system kill session command you issue and the oraclexxxxx unix command that this leaves running