473,396 Members | 1,816 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,396 software developers and data experts.

regarding dynamic SQL

can anybody give the syntax?

How to use all_tab_columns in from clause with where codition in dynamic SQL (execute immediate) .
Jan 9 '08 #1
3 1389
debasisdas
8,127 Expert 4TB
the basic syntax of EXECUTE IMMEDIATE is

EXECUTE IMMEDIATE 'Your sql query' ;

do not add ; along with the query statment.
Jan 9 '08 #2
amitpatel66
2,367 Expert 2GB
can anybody give the syntax?

How to use all_tab_columns in from clause with where codition in dynamic SQL (execute immediate) .
Hi Madhavi,

Welcome to TSDN!!

Please make sure you follow POSTING GUIDELINES when ever you post in this forum

Thanks
MODERATOR
Jan 9 '08 #3
amitpatel66
2,367 Expert 2GB
can anybody give the syntax?

How to use all_tab_columns in from clause with where codition in dynamic SQL (execute immediate) .
Are you going to select the table_name or column_name from all_tab_columns to be used in execute immediate?
Jan 9 '08 #4

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

Similar topics

7
by: Squignibbler | last post by:
Hi all, I have a question regarding the C++ programming language regarding the nature of the relationship between pointers and arrays. If the statement MyArray is functionally identical to...
4
by: maadhuu | last post by:
hello, i want to know the proper meanings and usage of the following . a>. dynamic scoping (an online link will be extremely helpful . and what is lexical scoping or static scoping ?? b>....
8
by: Mike | last post by:
Hello, I have a few rather urgent questions that I hope someone can help with (I need to figure this out prior to a meeting tomorrow.) First, a bit of background: The company I work for is...
1
by: Arijit Chatterjee | last post by:
Dear Faculties, I have a query on this statement.. =============================== CREATE PROCEDURE Check_Manage ( ) DYNAMIC RESULT SETS 1 ============================== I want to know the...
1
by: jsever05 | last post by:
I am trying to build a reasonably large table (maybe 50 rows x 12 columns) dynamically on the server-side using the Table(), TableRow(), and TableCell() objects provided by ASP.NET. For various...
3
by: Henry | last post by:
I know it is possible to store dynamic propterties for applications in XML files. The app.config and the web.config files can be used to store AppSettings... I am just wondering how far one can...
0
by: =?Utf-8?B?Um9iZXJ0IENoYXBtYW4=?= | last post by:
Hi, I am designing a ASP.NET 2.0 front end for an activity based costing model and am interested in getting some general guidance on what design route to take. I can work out the specifics but...
4
by: vfpuglia | last post by:
Hi, Lets get it out there... I'm a newbie to javascript. I'm trying to build a string for the external source file destination and be able to change the keywords in the string based on what...
4
by: pratap | last post by:
Is there any way in which one can link a.so(Class implementation by Vendor A in a dynamic library) and b.so(Class implementation by Vendor A in a dynamic library) and use it in 1.cpp where 1.cpp...
4
by: wizwx | last post by:
The followings are a few lines of code from the Template method in "Thinking in C++" vol.2 pp.639 class ApplicationFramework { protected: virtual void customize1() = 0; virtual void...
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
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.