In Delphi 2010 I want to connect to a Oracle XE instance installed in my own machine using the ODAC components (TOraSession). When I set the parameters for the connection I got the \"ORA-12154: TNS: c
I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I
Does SQLDeveloper have a Toad-like tool t开发者_StackOverflowo copy/clone an Oracle database user?
i am new to oracle.Already there is a store procedure which fetches data from many tables.Due to performance issue,i need to modify it.So i want to know about materialised view (since,i already search
I have a bunch of SELECT statement scripts where I am pulling data for a bunch of different tables.As far as exporting that data and saving it, I have to manually run each query, right click and \"Sav
I\'m developing an app using Oracle database and I would surely like to have an SQL statements tracer that could trace sessions and processes statements - like Toad\'s SQL Tracker/Monitor. But since t
Is it possible to connect to an Oracle DB using a jdbc 开发者_如何学Cconnection string like: jdbc:oracle:thin:@myserver:1521:mydb
We use Subversion for source control and have implemented a pre-commit hook that checks for comments and does not allow commits without comments.
开发者_StackOverflow社区Can we get the table description through java code that we get by typing desc in Toad?Use DatabaseMetaData to get the table information.
I\'m just learning Oracle and I understand the concept of triggers and sequences. What I can\'t seem to find is how they are used together in an auto-increment fashion similar to a SqlServer Identity