How do I check if a sequence exists or not in Oracle 11g?
I am using Oracle 11g. I want to be able to determine whether a particular sequence exists or not. I have tried the code below but it is not working. (It is returning 0 as count value when there should be more):
WHERE sequence_name = 'SCHEMA.SEQUENCE_NAME';
If anyone knows why this is, please help me.
I need to drop a table and make a new one. If I drop the table and the table doesn't exist, I get an error How can I check if the table exists? I'm working on Oracle 11g Thanks in advance.
I am getting the following error connecting to an Oracle 11g database using a simple Perl script: failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS setting
I have 2 tables and the first two columns of these two tables are identical for example: Table_1 has SSN column and membershipId column Table_2 also has SSN and membershipId column. They're identical
I am using the external table approach with Oracle 11g to load data from files to the database. The files come from external sources and are of standard format. However, my application does not need
I am having this strange issue connection JDBC to Oracle 11g. It started happening suddenly this Monday without any settings changes that either me or the team were aware of. Reading in Stackoverflow
I am learning to generate XML in Oracle 11g PL/SQL language. I would like to generate XML depending on the data I get from the db tables, but at same time it should follow the structure and validate t
Possible Duplicate: How do I reset a sequence in Oracle? I would like to change one parameter of sequence LAST_NUMBER to some number, how can i do it through SQL query. ALTER SEQUENCE MSG_MESSAGE_SE
I'm running Oracle 11G . Assume I have table named TEST_TABLE . I can see it when run : SQL> SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME='TEST_TABLE'; TABLE_NAME ----------------------------
I've got an ASP.NET webapp, which uses Oracle 11g stored procedures, through ODAC (Oracle .NET data provider) I realized that updating the stored procedures seems more than often to break the website,
I would like to check if a view exists before I actually resolve it. Here is my controller, with some comments on how I'd like it to work. @RequestMapping(value=/somethinghere/) public String getSo
I understand that Oracle supports multiple character sets, but how can determine if the current 11g system where I work has that functionality enabled?
Currently I'm using the ojdbc14.jar Oracle 10g thin driver to access an Oracle 10g database. I would like to upgrade the driver to the thin ojdbc6.jar Oracle 11g driver ahead of the actual upgrade of
I have a table of size 6 TB which grows around 20 GB per day. I have tried the OLTP compression and secureFile compression but it gives compression ratio around 20% only. So I want to split the table
when i tried to import oracle database 11g into oracle 10g i got this error. IMP:00010 Not a valid export file. header failed identification IMP:00000 Import terminated unsucessfully any help please
I am experiencing some difficulty getting to the Oracle 11g Express Workspace in which resides my database. I am able to register my JDBC Driver via Class.forName(jdbc.oracle.driver.OracleDriver) an
I need to develop an ASP.Net web application accessing and Oracle 11g database. What would be the preferred method / framework to access the DB? At the moment I am using most of the time EF 4.x to acc
I know this command will create a directory: EXEC master.sys.xp_create_subdir 'C:\testing\' But how do I check whether 'C:\testing\' exists? IF EXISTS(...
I have been struggling to install Oracle 11g Express Edition on Ubuntu 12.04.1 LTS version. I have followed these steps: Downloaded 11g express edition from Oracle's site Created a new user 'oracle'
I want to check if a variable exists. Now I'm doing something like this: try: myVar except NameError: # Do something. Are there other ways without exceptions?
I have installed Oracle Database 11g Expressed Edition on my pc (windows 7) And I have installed SQL Developer as well. I want to create a simple database maybe with one table or two and then use SQL
I am using Oracle database and I'm having problem to get one result from 2 result sets. I have table CASES Create table cases (ID varchar(1), date_entered date, sub_category varchar (5)); insert into
How can I check if mysql table field even exists ? The column name is 'price' and I need to see if it exists. Haven't understood really how the 'EXISTS' works... Any examples or ideas ? Thanks
I'm using the oracle OIM 11g api (in packages oracle.iam). I use the class oracle.iam.platform.OIMClient to get all the OIM client services like UserManager. I need to find the resources got with the
I know this must be simple, but how do I preface the creation of a function with a check to see if it already exists? If it exists, I want to drop and re-create it.
Am seeing the below error while trying to connect to Oracle 11g on Red Hat Linux, 64-bit using thin jdbc drivers. Would highly appreciate if anyone can throw more light on how to go about troubleshoot
I'm using oracle 11G with OJDBC6.jar adapter. when I try to run this very simple insert statement, it throws an invalid character exception. ActiveRecord::JDBCError: java.sql.SQLSyntaxErrorException:
I used Oracle sequence as primary key of a table, and used int in Java application mapping this primary key, now I found my customer has reached to the maximum int in table, even the sequence can be c
I am trying to sync tables in a Oracle 11g and Sql Sever 2008 databases using the Sync Framework. I used the Database Sync: Oracle and SQL Compact 2-Tier Sample as a base and was able to extend it to
I have some humongous queries that run on gigantic tables. These queries seem to be CPU bottlenecked, and run for hours. I understand that Oracle has a lot of new features with 11g, release 2 to inter
I am trying to perform update action in Visual Studio 2010 Ultimate with Windows form as the front end and Oracle 11g express as the back end. I am using C# to code this. private void update_student(
I want to know, how to make Oracle Forms 10g or 11g more accessible to people with disabilities. For starters, is Oracle Forms compatible with web browser zoom level, if not, is there some way to dyna
I want to find a foreign key in a table, but there are changes to rename/alter the primary key. How can I determine the foreign key and primary key in the table? Relevant code: SELECT * FROM INFORMAT
Is Hibernate 3.0 compatible with Oracle 11g? in hibernate-3.0.jar we have OracleDialect which according to documentation,compatible with any Oracle version. So with Oracle 11g I suppose OracleDialect
hi i'm using oracle 11g to create a table with Object-Relational Features but its not creating the table for some reason here what i have create type Name as object ( firstname varchar2(20), surname
I have a partitioned table that belongs to tablespace report. I want to move it to tablespace record instead. One possibility is to drop the table and recreate it in the new tablespace, but that is no
In PostgreSQL, I can do something like this: ALTER SEQUENCE serial RESTART WITH 0; Is there an Oracle equivalent?
After retrieving a result set from an Oracle 11g database, it takes roughly 75 seconds to convert the XMLType (this is a structured XML Storage, registered with an xsd) into either a java String or Do
I need to shrink a tablespace in oracle 11g. It is not a temporary table-space, I cant lose the data in that tablespace. One of my other tablespaces is out of space so I have to reallocate the remaini
I'm using oracle 11g sql developer I have a varchar2 column with dates as 0523 (mmDD). I want to convert them to a date column and have them look like 23-05 (dd-mm).. Any ideas?
So, what I want to do is to block an insert if the condition is met. In this case, I'm developing a simple library database system and I don't want to allow someone to be able to borrow a book if that
How can one do a self outer join in oracle ? (I'm using 11g) I tried the following query with lots of combinations of (+) everywhere and left/right : select t1.name, t1.status, t2.status from my_tab t
I would like to upload an image from an asp.NET Web Forms (4.0) application to an Oracle 11g database. Eventually, I would also need to retrieve the image. I was told to use a blob type, but this can
I run oracle 11g and need to move table (tbl1) from one tablespace (tblspc1) to another (tblspc2). What is the easiest way to do that?
I have a server with both 10g and 11g clients installed. How do I setup the connection string to tell my ASP.NET application to use the second client which is 11g (i.e. OraClient11g_home2)?
is there any problem to install different oracle 11g versions. I mean if I have installed oracle 22.214.171.124 and i do install oracle 126.96.36.199 will anything conflict, such as oracle_home path, or any regi
Im trying to get NHibernate to work with Oracle 11g´s XmlType. The following Exception is thrown: Dialect does not support DbType.Xml My configuration looks like: <?xml version=1.0 encoding=utf
I want to audit 2 tables (select,insert,update,delete) on an Oracle 11g standard edition. Someone told me, that the AUDIT command is just allowed with the enterprise edition. Is it possible with a Ora
i wrote a program to connect to the database in java 1.7 and my database is oracle 11g express edition iam getting class not found error for the class OracleDriver?
I've seen discussions about this in the past, such as here. But I'm wondering if somewhere along the line, maybe 10g or 11g (we are using 11g), ORACLE has introduced any better support for parameteri
This question already has an answer here: MS Access to Oracle easy Conversion / Migration 1 answer I can export Access tables one by one using the Oracle ODBC in access. How can i do all tables