Home » SQL & PL/SQL » SQL & PL/SQL » a procedure with dinamic sql
a procedure with dinamic sql [message #672555] Wed, 17 October 2018 16:19 Go to next message
jasminzeni
Messages: 1
Registered: October 2018
Junior Member
HI all, i need help , i need a dynamic query that generates a select and executing the select i take names of tables and number of records in a database ,can anyone help with an example ?
Re: a procedure with dinamic sql [message #672556 is a reply to message #672555] Wed, 17 October 2018 16:23 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
jasminzeni wrote on Wed, 17 October 2018 14:19
HI all, i need help , i need a dynamic query that generates a select and executing the select i take names of tables and number of records in a database ,can anyone help with an example ?

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Please click on URL below

http://lmgtfy.com/?q=oracle+dynamic+table+name+in+SELECT
Re: a procedure with dinamic sql [message #672558 is a reply to message #672555] Wed, 17 October 2018 16:39 Go to previous messageGo to next message
pablolee
Messages: 2881
Registered: May 2007
Location: Scotland
Senior Member
Why do you need this? Is it a homework assignment, or is there a business reason?
If the former, show us what you've tried so far, if the latter, explain the business need for such a thing, with some sample data
Re: a procedure with dinamic sql [message #672587 is a reply to message #672555] Fri, 19 October 2018 02:52 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
This group has a lot of knowledgeable and helpful members. However, you need to show us what you have tried thus far to receive further assistance.
Re: a procedure with dinamic sql [message #672679 is a reply to message #672587] Tue, 23 October 2018 07:33 Go to previous message
Bill B
Messages: 1969
Registered: December 2004
Senior Member
What their trying to say is that we will not spoon feed answers to questions. The end user will never learn anything that way. However if you show what you have tried we will be more then glad to help you out.
Previous Topic: Written Assignment (+ example code)
Next Topic: PLS-00201: identifier 'CTX_DDL' must be declared
Goto Forum:
  


Current Time: Tue Sep 29 22:29:19 CDT 2020