Search results for query: *

Thanks for the quick response @taupirho. Thats the answer to my original question, thanks! Now I'm struggling with include files - theres a few around with the latest DEV-C++ so I need to experiment a bit more. The Pro*C precompiler doesn't like most of the includes that are available!

Hi All, Does anyone have any experience compiling Pro*C on Windows 7? Specifically, I'm trying (and failing) to compile any Pro*C at all using Dev-C++. I do not have Visual Studio installed, nor can I. I have installed the Oracle Instant Client 11.2.0.4.0, but all I can get from the...

I worked out the solution, and it's easier than I thought. I'll share my solution in case anyone else wants to know. Here's my code applied to a bubble sort: Structure holidayStructType Public holidayDate As Date Public holidayName As String End...

Thanks for the swift reply. However, I did look at that page and it doesn't specifically answer my question about the use of a structure type. Perhaps I should have been a little clearer in my OP. I want to look for the element of a structure in the linked list, where I know the value of...

Hi All, This is my first post for quite some time, having been active on some of the Oracle forums a while ago. I hope someone out there can point me in the right direction. I'm picking up VB.Net using Visual Basic 2010. I've used linked lists in C very effectively in the past, and I'd like...

I should also add we use quite a lot of external tables, usually CSV files, and these are also neastly stored on the encrypted volume.

Hi thargtheslayer, thanks for the very useful post. I hear you about the third party software issue, which is fair to say. But we have completed quite a lot of testing with this setup and I have to say it seems pretty robust. To be honest, I don't see the volume space being an issue because if...

Thanks for all your excellent replies as usual, guys. Our company requires that the entire database (read: tablespace(s)) is encrypted. ASO would be the ultimate solution, but we will need to take a look at the pricing very carefully. If DBMS_CRYPTO is like obfuscation toolkit, it is not...

Brilliant! A bit of googling and I found this. Thats the info I needed to know - thanks thargtheslayer. With thanks to Decipher Information Systems http://decipherinfosys.wordpress.com/2008/02/05/encrypted-tablespaces-in-oracle-11g/. [2thumbsup]

Thanks Dave. In that case my preferred method will be to store the tablespace files within a secured encrypted volume.

Can someone explain how, if at all, Oracle 11g data is secured in a tablespace? By this I mean, if I store some data in a table, then some 'person' removes the hard drive from the server to examine the raw data on the drive, would they be able to read the data directly? If so, whats the best...

Remove the FK link and create a link that is simply group-to-group. To do this, select the link tool then drag the group header from Q_FIRMS to the header of the Q_1 group. In your query for Q_1 you can then wite it asSELECT DISTINCT * FROM firms f, products p WHERE f.license_no = :license_no...

Is this straight PL/SQL or forms/reports? This points to an invalid parameter value in a procedure call, but I usually see this in forms.

To continue with Andrzejeks answer, SYSDATE is a pseudo-column so you can include it directly in the query:WHERE TIME-Admission.FULLDATE BETWEEN ADD_MONTHS(SYSDATE,-6) AND SYSDATE

You can create links between databases through which normal queries can be run.

SQL Developer available free from Oracle.

Use a cursor loop. DECLARE CUSROR cur1 IS SELECT blah FROM waffle ORDER BY primary_key; BEGIN FOR loop1 IN cur1 LOOP do_something; END LOOP; END;

Are you using forms, reports, SQLPlus, or something else?

You could check in ALL_VIEWS for the view definition, or ask your system admin to check it for you. In SQL*Plus SET LONG 4000 SET PAGES 0 SELECT text FROM all_views WHERE view_name = '<VIEW NAME>'; From that you can determine which table(s) is/are affected and the WHERE clause that would...

SELECT * FROM table WHERE Translate(Translate(Upper(field), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ','~~~~~~~~~~~~~~~~~~~~~~~~~~'), '0123456789','@@@@@@@@@@') = '~@@@~~';