a) the "table" type is not needed in your example, as your variable is of type varray (so your "as NumberTable " should have been "as NumberArray) b) when dealing with table/varray of (scalar datatype), Oracle maintains a pseudo-column called "column_value" that holds the value of the row. [email protected]> update ( select ename,dname 2 from emp e, dept d 3 where e. The CREATE TABLE AS SELECT allows you to create a table from the results of a SELECT statement. Table partitioning is about optimizing “medium selectivity queries”. For this example, lets use the scenario where we have a table that contains the access logs of every user. If you need to randomly select one or more rows from one of your tables, then you can use the following query. Create and execute an equijoin between DJs on Demand tables d_track_listings and d_cds. Insert data into new (or existing table) from another (T-SQL, PL/SQL, SQL Server, Oracle) December 24, 2013 by Carlos Ferreira 4 Comments Often times we wish to copy data from one table into another. E Email: [email protected] This all is due to fragmentation in the table or stats for table are not updated into dba_tables. For example, assume a select statement returns the following 'SMITH,ALLEN,WARD,JONES'. Notice the EXISTS predicate to exclude rows from the DEST_TAB table with no matching row in the SOURCE_TAB. If you use the SELECT DISTINCT statement to query data from a column that has many NULL values, the result set will include only one NULL value. deptno ) 4 set ename = dname; set ename = dname * ERROR at line 4: ORA-01779: cannot modify a column which maps to a non key-preserved table. You must make sure such a plan table exists. This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement with syntax and examples. Home » Articles » 9i » Here. I want to insert data to Oracle 11g table from SQL Server 2008 R2. The related tables of a large database are linked through the use of foreign and primary keys or what are often referred to as common columns. I am working in Oracle technology since 2004. The other answers are excellent, although I'd like to take a slightly higher level view. The best way to learn is to learn by example. If you need to randomly select one or more rows from one of your tables, then you can use the following query. The DUAL table was created by Chuck Weiss, an employee of Oracle Corporation. Hello, I want to SELECT into a TEMP TABLE. Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at [email protected] SELECT owner, table_name FROM dba_tables; To be able to see this data, you need to have database administrator privileges. Parallel Table. When table locks is present on any tables in Oracle we cannot run DDL on those tables. It's one way to create a table. You can select as many column names that you'd like, or you can use a "*" to select all columns. To use this. owner in (select username from all_users where oracle_maintained = 'N') Including specific schema only. Starting from 11g Oracle does all this work for you. Oracle Create Table As for beginners and professionals with examples on insert, select, update, delete, table, view, join, key, functions, procedures, indexes, cursor. Multiple rows are inserted into a table using the INSERT ALL statement and by using the inserting the results of the select query. Since we have already mentioned the SELECT command in this INSERT tutorial, let's see how to use the SELECT command to create a new table and populate with data from an existing table. Hi I am having three oracle databases running in three different machine. 13 Using Pipelined and Parallel Table Functions. It is stored in two locations: data dictionary tables (accessed via built-in views) and a metadata registry. I knew that you could have Query Table expressions in the "from" clause but I was not aware that Oracle allowed you to have these in the "select" clause also. ERROR: CREATE TABLE/AS SELECT has mismatched column count. objectid does not have unique constraint on it. Before you can jump in with the inner-workings of today's topic, you will need some background information. In Oracle 10g release 1 and above, Oracle treats the use of DUAL the same as calling a function which simply evaluates the expression used in the select list. It’s one way to create a table. Category SQL General / Data. When table locks is present on any tables in Oracle we cannot run DDL on those tables. There are two options. select * from (select table_name from user_tab_columns a where column_name like 'PK_ACCOUNTNO') hi thanks for ur reply but it didnt solve my doubt i want to select data from the info obtained by the inner query can u help me regards, swapna. The ability to join tables will enable you to add more meaning to the result table that is produced. Oracle: select 'something' from dual. hi anil once again i appreciate urs effort. SQL> CREATE TABLE. Select the LAST N rows from a table in Oracle;. In SQL Server DUAL table does not exist, but you could create one. The Oracle INSERT INTO SELECTstatement requires the data type of the source and target tables match. Teorey Table of Contents Oracle/logging-in 1 Nested subqueries 5 SQL create table/naming rules 2 Complex functions 6 Update commands 3 Save a query/perm table 6 Select commands 3 Special commands 6 Set operations 4 SQL views 9 Built-in functions 4 Index 10 Oracle. spool checkstat. It also explains the generic datatypes ANYTYPE, ANYDATA, and ANYDATASET, which are likely to be used with table functions. See the locations table in the sample database. This would result in less I/O, meaning better performance ;) But need to make sure that the data does not changes in the sourec table in the middle of the process ;). To issue an Oracle Flashback Query using the flashback_query_clause , you must have the SELECT privilege on the objects in the select list. These are simple conditions in Oracle SQL which is used for same column reusability. display); EXPLAIN PLAN FOR SELECT srvr_id FROM cservers s WHERE EXISTS ( SELECT srvr_id FROM. MySQL allows DUAL to be specified as a table in queries that do not need data from any tables. 'orders' table used as alias 'a' and alias 'b'. (check out the associated Data Model). [email protected]> create table dept as select * from scott. MAX function will return the Maximum value for the column used in function and MIN will return the Minimum value for that column. There isn't an Oracle show tables command specifically, but the first method is using the dba_tables view. As you can see that using JOIN clause in UPDATE statement it makes it very easy to update data in one table from another table. I query a table which has another table name in one column. Esse conceito foi introduzido no Oracle…. The table has no primary key and no auto increment value. Please do feel encouraged to read this and my other posts on table functions, but you will learn much more about table functions by taking my Get Started with PL/SQL Table Functions class at the Oracle Dev Gym. how to Insert the result of a function into a table how to Insert the result of a function into a table. Select the LAST N rows from a table in Oracle;. Use the Select Oracle Tables and Columns page to select the tables from the Oracle source database where changes are captured. The INSERT INTO SELECT statement copies data from one table and inserts it into another table. SELECT owner, table_name FROM dba_tables; To be able to see this data, you need to have database administrator privileges. The AS OF timestamp clause can also be used inside INSERT or CREATE TABLE AS SELECT statements. We often need to find and delete duplicate rows from oracle table due to many reasons in the database. In Oracle Database 11g, your partitioning choices are now virtually limitless. Developers are able to specify the AS OF clause for a single-table, multiple-tables (joins) as well as specify different times for different tables. How to download blob file from oracle table. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees. Summary: in this tutorial, you will learn how to use the Oracle SELECT statement to query data from a single table. SELECT * FROM TABLE(StockPivot(CURSOR(SELECT * FROM StockTable))); In the preceding query, the pipelined table function StockPivot fetches rows from the CURSOR subquery SELECT * FROM StockTable, performs the transformation, and pipelines the results back to the user as a table. Handy if you've just deleted all the rows! select * from. SELECT INTO Syntax. The other answers are excellent, although I’d like to take a slightly higher level view. In a single statement, the table is created and populated. For this example, lets use the scenario where we have a table that contains the access logs of every user. CREATE TABLE EMPLOYEES ( id NUMBER, data XMLTYPE);. Category SQL General / Data. Insert into a temporary with select statement. It’s one way to create a table. select statement view count view table access by index rowid, 20090506_rownum. I have an event table that specifies a date range with start_date and end_date fields. If you use the SELECT DISTINCT statement to query data from a column that has many NULL values, the result set will include only one NULL value. With solutions for Toad for Oracle, Toad for MySQL, Toad for SQL Server, DB2, SAP and more. If you wish to determine the number of rows that will be deleted, you can run the following Oracle SELECT statement before performing the delete. -- Check the content of the table SELECT * FROM Table1 SELECT * FROM Table2 GO. Consider a table EMPLOYEES which holds some XML data. I have an event table that specifies a date range with start_date and end_date fields. INSERT INTO SELECT requires that data types in source and target tables match. This Oracle tutorial explains how to use the Oracle INSERT statement with syntax, examples, and practice exercises. petsName as Cats FROM ANIMALS as A INNER JOIN ANIMALS AS B. The varray's key distinguishing feature is that when you declare a varray type, you specify the maximum number of elements that can be defined in the varray. selecting columns from two different tables oracle selecting columns from two different tables oracle. table is the partitioned table. This Oracle tutorial explains how to use the Oracle SELECT statement with syntax, examples, and practice exercises. Script Name Varray Examples; Description The varray (variable size array) is one of the three types of collections in PL/SQL (associative array, nested table, varray). In this code snippet, Deepankar examines the usage of Oracle's ROWNUM keyword to select the nth row of a table. UPDATE rows with values from a table JOIN in Oracle Example use case: I have a database that contains a table of contacts (contact) and table of e-mail addresses (email), joined on contact. For each employee, find all less earning people with the same role – here we need to perform two actions: 1) left join the table with itself using the role field. I am looking to select the column names in a table. Clear answers are provided together with tutorial exercises to help beginners on creating, altering and removing tables, adding, altering and rem. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Viewing Tables Owned by Current user. Simple Example - Generating Some Random Data. The new table gets the same column definitions. re: select clob from table 405193 Oct 23, 2003 3:12 PM ( in response to 402139 ) Maria, your stmt works fine till 4000 bytes. There is no need of Dual table in SQL Server at all. To use this. See the locations table in the sample database. DESC[RIBE] (SQL*Plus command) Describe an Oracle Table, View, Synonym, package or Function. The fields of the PL/SQL record has the same name and data type as the column of the table. There are two options. Any ideas? How can i suppress 'logging'? I don't want Oracle. In Oracle SQL Developer, an easy way to construct a SELECT statement is to drag and drop a table name from the TABLES node in the Connections Navigator into the SQL Worksheet. Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. how should i get the record in a single select statement. CREATE TABLE EMPLOYEES ( id NUMBER, data XMLTYPE);. You may have to register before you can post: click the register link above to proceed. An email has been sent to verify your new profile. Please do NOTE that at runtime BOTH of them will have the same plans. Listing Tables in SQL Server 2000. Oracle | Toad expert blog for developers, admins and data analysts. SQL delete records using subqueries with alias and MIN and COUNT. Today in this post I'll talk about how to read/parse JSON string with nested array of elements, just like XML. Here Not Null Constraints cannot be named but all other constraints and indexed can be named. Consider a table EMPLOYEES which holds some XML data. Karthick_Arp wrote: If i have to use a specific set of rows from a huge table in my procedure repeatedly i would opt to store them in a Nested Table and use that. ALL_TABLES describes the relational tables accessible to the current user. I have created a linked server and the connection was successful. Get list of all tables in Oracle? 873. A copy of an existing table can also be created using CREATE TABLE. iii) Perform the sub-query with the current value. SQL Pattern: Select trim…. Developers are able to specify the AS OF clause for a single-table, multiple-tables (joins) as well as specify different times for different tables. SQL INSERT INTO SELECT Values, Same Table. SELECT MAX(nom_colonne) FROM table. Oracle INSERT INTO SELECT examples. TABLES WITH MORE THAN 5 INDEXES NOTES: Owner - Owner of the table Table Name - Name of the table. Oracle Create Table As for beginners and professionals with examples on insert, select, update, delete, table, view, join, key, functions, procedures, indexes, cursor. The DUAL table was created by Chuck Weiss, an employee of Oracle Corporation. Base Management System) e. Oracle performs a join whenever multiple tables appear in the query's FROM clause. In this page, we are going to discuss, how rows can be removed from a table by SQL DELETE statement along with the SQL MIN() and COUNT() function. See Series TOC "Divide and conquer"—that figurative principle has never been better illustrated than by Oracle Database's partitioning features. List Tables Using DBA_TABLES. Select * from table where 1=0 return just header of the fields (attribute) but with 0 rows 2. There's couple of problems here: - "index by binary integer" is PL/SQL only, but you're creating it with SQL - You need to select the object when bulk collecting your data. DESC[RIBE] (SQL*Plus command) Describe an Oracle Table, View, Synonym, package or Function. deptno ) 4 set ename = dname; set ename = dname * ERROR at line 4: ORA-01779: cannot modify a column which maps to a non key-preserved table. USE AdventureWorks GO ----Create a new table and insert into table using SELECT INSERT SELECT FirstName, LastName INTO TestTable FROM Person. I have been searching on internet about as mentioned in the PROBLEM SUMMARY but no luck. Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at [email protected] selecting columns from two different tables oracle selecting columns from two different tables oracle. I used to use this kind of statement when working with Oracle7 without the PARTITION Clause. Get list of all tables in Oracle? 873. One of the great features about partitioning, and most specifically range-based partitioning, is the ability to load data quickly and easily with minimal impact on the current users using: alter table call exchange partition data_2007 with table call_temp;. id ) ; Now, each time the above is executed, it will do it across all rows in the table. ALL_TABLES describes the relational tables accessible to the current user. Get single records when duplicate records exist. Using the SELECT statement, you can choose the rows in a table that you want returned from a query by specifying values to match the rows that you want to display. After they're inserted into the table, enter select statements to: Select all columns for everyone in your employee table. sql" script or custom queries of the plan table. If you do not have those privileges but need them, you can request that the DBA explicitly grants you privileges on that table, or, that the DBA grants you the SELECT ANY DICTIONARY privilege or the SELECT_CATALOG_ROLE role (either of which would allow you to query any data. Script Name SELECT * FROM [table] with PL/SQL procedure; Description "In Table" utility: use DBMS_SQL to implement a Method 4 dynamic SQL challenge. I query a table which has another table name in one column. See example of that at the bottom of this solution. CREATE EXTERNAL TABLE AS SELECT (Transact-SQL) 08/10/2017; 9 minutes to read +2; In this article. The reason we’re using a table variable is temporary and will be removed once query session is closed. In Oracle 12c, the TABLE operator can now be used in PL/SQL with locally defined types. Oracle: return a »table« from a function. select count(*) from partition (name) takes around 10 mins to count 70,000 rows. This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement with syntax and examples. Starting in Oracle9i release 2, there was an incorporation of a subquery factoring utility implemented the SQL-99 WITH clause. You can select as many column names that you'd like, or you can use a "*" to select all columns. APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse. Temporary Tables. In Oracle Database 11g, your partitioning choices are now virtually limitless. See example of that at the bottom of this solution. (select B. NESTED TABLE is an Oracle data type used to support columns containing multivalued attributes, in this case, columns that can hold an entire sub-table. It's doing a full scan of the partition but this stills seems a long time, even if the data isn't already cached. The Oracle SELECT statement is used to retrieve records from one or more tables in an Oracle database. Which is the default values for those columns. After contributing few articles on Microsoft SQL Server, I thought it would be a good time to do something Oracle specific. With MySQL you easily create an alias like this: SELECT p. SQL command to list all tables in Oracle. Summary: in this tutorial, you will learn how to use the Oracle SELECT statement to query data from a single table. Free Oracle Magazine Subscriptions and Oracle White Papers: Oracle Select Statements: Version 11. With collections and the table() function, a function can return a table that can be queried in an SQL statement. The user can issue a simple select statement that is designed to pull all data from the table shown in Table 1-1. For this example, lets use the scenario where we have a table that contains the access logs of every user. I need to copy the table A columns data to table B by one-one column. Insert data into new (or existing table) from another (T-SQL, PL/SQL, SQL Server, Oracle) December 24, 2013 by Carlos Ferreira 4 Comments Often times we wish to copy data from one table into another. If the employees table has 100 rows and 20 of those have department_id set to 10, then there will be 20 context switches from SQL to PL/SQL to run this function. SQL delete records using subqueries with alias and MIN and COUNT. oracle apps workflow scripts tables. Based on privileges we can query oracle's all_tables,user_tables,all_all_tables,dba_tables to list all tables. Relational databases comprise structured data so the data in a table is specific in format, validated at the time of creation and organized as rows w. I have created a linked server and the connection was successful. So that’s how you can generate a pivot table in Oracle SQL without aggregates. A more permanent solution is to add a date-time column (or a sequence) to the table. This way you can quickly understand different aspect of the API. Query to list concurrent program details with its parameter, values set and default value/type AND Attached Responsibilities 1. The Oracle INSERT INTO SELECTstatement requires the data type of the source and target tables match. Generating and displaying. It does that by using SELECT DISTINCT and selecting the Hours(A) value and the Hours(B) value for each column for the unique ID. SELECT Column1, * FROM MY_TABLE This is useful for visibility reasons, however that doesn't seem to work in ORACLE and I don't know how to achieve it, other than writing down all the Column Names manually. With solutions for Toad for Oracle, Toad for MySQL, Toad for SQL Server, DB2, SAP and more. I have two tables (table A, table B). This post shows how to take a spreadsheet and transform it into a new table in your Oracle database. Listing Tables in SQL Server 2000. dataset is the dataset containing the partitioned table. Aliases allow you to reference the table name with an abbreviation. Mini User's Guide for SQL*Plus T. all_tables lists all tables that have user access,user_tables lists all tables owned by the user,dba_tables displays all tables in the database. The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline. Open the two tables (tblClients and tblLeads) and examine their structure and data. How to Select Rows with MAX Value for a Column in Oracle SQL. DISTINCT treats NULL values to be duplicates of each other. I have installed Oracle 11g client in server machine. Category SQL General / Data. Select * from table where 1=1 return whole table entries this is same as select * from table I guess someone set this query for easy change from select all to select none. I need to copy the table A columns data to table B by one-one column. In some cases, we get a comma separated string as output (say from another select statement) that we would need to pass to the IN clause of a select statement. iii) Perform the sub-query with the current value. all_tables lists all tables that have user access,user_tables lists all tables owned by the user,dba_tables displays all tables in the database. all field names. [email protected] Some useful syntax reminders for SQL Injection into Oracle databases… This post is part of a series of SQL Injection Cheat Sheets. Declaring Table-based Record. Viewing Tables Owned by Current user. Can I create a temp table on the fly? For example: SELECT * INTO TEMP_TABLE (doesn't yet exist) FROM. objectid does not have unique constraint on it. The removal of this restriction means this functionality is. This post covers how you can use the PL/SQL package DBMS_XPLAN to display execution plan information. SQL delete records using subqueries with alias and MIN and COUNT. When table locks is present on any tables in Oracle we cannot run DDL on those tables. Suppose you own emp table. It's great for summarising results like this that don't have a number value. Use the Select Oracle Tables and Columns page to select the tables from the Oracle source database where changes are captured. You can replace where clause above with this line: where tab. In its simplest form, CREATE TABLE AS statement will create a complete backup of an existing table including all columns and data simply by using the statement: CREATE TABLE new_table_name AS SELECT * FROM existing_table_name. The varray's key distinguishing feature is that when you declare a varray type, you specify the maximum number of elements that can be defined in the varray. EMPNO)[/box. id ) ; Now, each time the above is executed, it will do it across all rows in the table. Table partitioning is about optimizing “medium selectivity queries”. dataset is the dataset containing the partitioned table. The CREATE TABLE AS SELECT allows you to create a table from the results of a SELECT statement. May be this is the reason why oracle Copy only table structure , record and Not Null constraints during CTAS process ( Create Table As Select). Back to Top. There are two options. all_tables lists all tables that have user access,user_tables lists all tables owned by the user,dba_tables displays all tables in the database. Summary: in this tutorial, you will learn how to use the Oracle FETCH clause to limit the rows returned by a query. DESC[RIBE] (SQL*Plus command) Describe an Oracle Table, View, Synonym, package or Function. Currently working in U. To list all the tables related the current user, enter SELECT table_name FROM user_tables; To list the tables accessible by the user, key in. I am working in Oracle technology since 2004. DISTINCT treats NULL values to be duplicates of each other. SELECT EDT_RACNUM_ID For example, in a table where pets are listed by owner SELECT A. 2, “JOIN Syntax”). You can select as many column names that you'd like, or you can use a "*" to select all columns. mytable index full scan, 20090506_rownum. Notice the EXISTS predicate to exclude rows from the DEST_TAB table with no matching row in the SOURCE_TAB. Instead of thinking in terms of columns and tables when you query the database, you can simply select a customer. This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement with syntax and examples. Handy if you've just deleted all the rows! select * from. Depending on the version of SQL Server you are running, the method for querying and returning a list of all user-created tables may differ slightly. You can see in the table that there is only one record for each state, and it shows the person record for it. id ) ; Now, each time the above is executed, it will do it across all rows in the table. There isn’t an Oracle show tables command specifically, but the first method is using the dba_tables view. Using this method we can create a temporary table to hold the data while we process it. It was introduced in Oracle 9i as a replacement for the "utlxpls. table WHERE _PARTITIONTIME IS NULL Where: column is the name of a column to query. without a PL/SQL function). This Oracle tutorial explains how to use the Oracle SELECT statement with syntax, examples, and practice exercises. dept; Table created. I created the person_rec as object and person_tbl as table of that object. How to read BLOB data from Oracle table Showing 1-7 of 7 messages. To issue an Oracle Flashback Query using the flashback_query_clause, you must have the SELECT privilege on the objects in the select list. Display all the information of the EMP table? A) select * from emp; 2. Trata-se de um conceito análogo ao da lixeira do Windows. table is the partitioned table. Oracle Database provides information about all of the tables, views, columns, and procedures in a database. SQL> CREATE TABLE. Pipelined Table Functions. Select into takes the values name, address and phone number out of the table employee, and places them into the variables v_employee_name, v_employee_address, and v_employee_phone_number. I work with very large Oracle enterprise databases all the time. Please do feel encouraged to read this and my other posts on table functions, but you will learn much more about table functions by taking my Get Started with PL/SQL Table Functions class at the Oracle Dev Gym. So, I am providing a sample SQL for Future reference. The code on this page shows how to use Oracle PL/SQL to retrieve the top 1 record. CONN test/test CREATE TABLE t1 AS SELECT level AS id FROM dual CONNECT BY level = 100;. It's a powerful and useful feature of the. The fields of the PL/SQL record has the same name and data type as the column of the table. Conclusion. Select value from table into variable : Select Into « PL SQL « Oracle PL / SQL. PL/SQL table functions accept and return multiple rows, delivering them as they are ready rather than all at once, and can be made to execute as parallel operations. Welcome to today's article. EMPNO)[/box. The DBMS_XPLAN package is used to format the output of an explain plan. responsibility_name, furg. This first Oracle article of mine. The Forms “From Clause” query is the perfect solution and is easier to implement and is more efficient than building a form based on the primary table in a join and then using the block Post-Query trigger to retrieve the needed values from related tables and the From Clause query. So, you write a SELECT statement that returns some columns and some data, and this is used to create the table. Can I use > > multiple partition name in my query. When table locks is present on any tables in Oracle we cannot run DDL on those tables. i mean to say process of inteview. It is suitable for use in selecting a pseudocolumn such as SYSDATE or USER. The following contains information on how to retrieve database information for Oracle objects such as tables, views, indexes, packages, procedures, functions, and triggers. Consider a table EMPLOYEES which holds some XML data. Notice the EXISTS predicate to exclude rows from the DEST_TAB table with no matching row in the SOURCE_TAB. In this post we will learn about Oracle XMLTable function. Oracle Database provides information about all of the tables, views, columns, and procedures in a database. The SELECT ANY TABLE system privilege also allows you to select data from any table or any materialized view or the base table of any view. Oracle: select 'something' from dual. select max(LOB_ID) into ctrl from LOB_INSERT; -- used to download all files of table. Steps to Check and Remove Table. This Oracle tutorial explains how to use the Oracle SELECT statement with syntax, examples, and practice exercises. Display all the information of the EMP table? A) select * from emp; 2. As it turns out, Oracle provides features that would allow us to more directly formulate our queries by applying functions to the nested tables, rather than by selecting from them. select count(*) from partition (name) takes around 10 mins to count 70,000 rows. These are simple conditions in Oracle SQL which is used for same column reusability. In this post we will learn about Oracle XMLTable function. If you use the SELECT DISTINCT statement to query data from a column that has many NULL values, the result set will include only one NULL value. Basically these kind of conditions used in reporting pur. Given a query that returns the name of tables, is it possible to evaluate the name and use it in a subsequent query? E. Let Uncle Oracle sort it out. Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at [email protected] ORACLE-BASE - Pipelined Table Functions Articles Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Oracle 13c Oracle 18c Oracle 19c Miscellaneous PL/SQL SQL Oracle RAC Oracle Apps WebLogic Linux MySQL. Given a table T, the query SELECT * FROM T will result in all the elements of all the rows of the table being shown. selecting columns from two different tables oracle selecting columns from two different tables oracle.