473,386 Members | 1,733 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How to determine if the table exist in oracle?

i want to know the code that will determine if the table is existing and if the table exist i will drop it..
Can you give me some source code on that problem?
Nov 2 '06 #1
2 7366
debasisdas
8,127 Expert 4TB
Qestion moved to Oracle Forum.
Nov 3 '07 #2
debasisdas
8,127 Expert 4TB
try to use the following

Expand|Select|Wrap|Line Numbers
  1.  select count(1) from user_tables where TABLE_NAME     =upper('tablename');
If it returns 1 then then the table exists in the schema.

Then you can drop the table using

DROP TABLE TABLE_NAME
Nov 3 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: valexena | last post by:
In which table is Oracle database audit information stored? -- Posted via http://dbforums.com
2
by: google_user | last post by:
Hi, I need to create a table in Oracle DB using SQL before which I need to check if it exists or not, where the dbuser will have CONNECT and RESOURCE privileges granted. All this needs to be...
2
by: narasingarao | last post by:
Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle data base tables...so, please help me in getting...
5
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because...
0
by: Jared | last post by:
Hi, I would like to delete rows only if table exist to prevents errors. Also I would like to add column only if it doesn't already exist. Thanks Jared
0
by: quiquef | last post by:
Hi, I am sending emails to students using PL/SQL. My problem is: if the student wants to unsubscribe from the mailing list. How can I load that into a table using Oracle PL/SQL.
3
by: Markus Weber \(Megalith GmbH\) | last post by:
Hello! I just want to check with "ADO" and "SQLConnection" if a table exist and what columns the table have. Does somebody know how to do that? Thanks in Advance! Markus
5
by: Naveen Kumar Srivastava | last post by:
Hi to All I want to create a table in oracle having name more than 16 character how i can? I know that oracle support table namt upto 28 character by default it support 15 character but i don't...
2
by: Zeeshan Akbar | last post by:
I want to create a table on Oracle on a click event of a button on ASP.NET. My webpage need a dynamic structure of table creation on the back-end (which I have connected with Oracle...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.