Skip navigation.
Home

Site Search

Search words: tab* Total hits: 95593
Search time: 18.510 seconds Run time: 18.521 seconds

Problems with a GROUP BY inside a SUBQUERY, using collections in Oracle 9i Open in New Window- Rank: 1000
… ke this SELECT ... FROM (SELECT A FROM TABLE(CAST(myTable1 AS TABLE1)) GROUP BY A,B,C ) X, TABLEA, TABLEB WHERE ... myTable1 is an instance of a collection named TABLE1, the external select has other tables, some collections and some SQL tables. I've …
/forum/t/16564/2/ - 13453 - 2004-08-05 13:19:04 CDT -   [ Highlight ]

Select the Multi Rows of Column in single Row. Open in New Window- Rank: 740
… ngle Row. Ex. Select Column1 from Table; Column1 Patna Mumbai Delhi I needed this data in single row like Patna Mumbai Delhi If it Passable Please reply me. Re: Select the Multi Rows of Column in single Row. Search for "pivot". …
/forum/t/124258/2/ - 37844 - 2008-09-06 08:33:55 CDT -   [ Highlight ]

PLSQL to SQL Open in New Window- Rank: 689
… o SQL Hi All, I want to compare common tables in all the schemas. the table names have the schema attached at the end. Example: Schema DON table name TABLE_NAME_DON Schema ACS table name TABLE_NAME_ACS I have written a plsql which does the work, but …
/forum/t/137572/2/ - 10752 - 2008-12-18 14:38:30 CST -   [ Highlight ]

Query help for adding columns (merged) Open in New Window- Rank: 652
… I need a query where I should add each TableC value as an additional column. Please suggest, I am sorry if formatting is not correct... I have 3 tables (TableA, TableB, TableC). TableB stores TableA Id and TableC stores TableB Id Considering Id of …
/forum/t/139280/2/ - 6692 - 2009-01-20 15:50:06 CST -   [ Highlight ]

ORA-00604,ORA-00904 error Open in New Window- Rank: 567
… tes) . Indeed it is a wrong design of database. Rajuvan. Re: ORA-00604,ORA-00904 error Quote:an internal view created for some reason.i.e, VW_NSO_2 Internal to you or to Oracle? Quote:The query contains rule hint and works fine when being execute …
/forum/t/125339/2/ - 26991 - 2008-09-25 10:54:03 CDT -   [ Highlight ]

Joining Oracle Text results with multiple tables / Performance Problems Open in New Window- Rank: 554
… ining Oracle Text results with multiple tables / Performance Problems I am having a problem with a SQL Query that is taking too long to execute (46 seconds). When the SQL Query is split into two separate queries each one runs at less than 1 second each. ( …
/forum/t/99703/2/ - 20818 - 2009-02-25 22:55:57 CST -   [ Highlight ]

changing tablesapce of tables &urgent Open in New Window- Rank: 537
changing tablesapce of tables &urgent Dear Sir, i had query about database admin level.Can u ask to ur friend as DBA. our company created a db around 4months before.The Big mistake done is they created the tables in system tablesapce..SO as u know the sys …
/forum/t/26672/2/ - 18475 - 2004-01-29 04:55:10 CST -   [ Highlight ]

duplicate records Open in New Window- Rank: 533
… I want to delete duplicate records from table . this table holds primary key value for other three table. now I want to delete only those records which are not primary key for other table. I thought this query will work but it's returning all duplic …
/forum/t/95367/2/ - 14650 - 2008-01-17 09:55:31 CST -   [ Highlight ]

Why does t.rowid = t.rowid improves performance? Open in New Window- Rank: 531
… or me at least) tuning method - forcing tables to access specific table indexes using where conditions like table.rowid = table.rowid (the same table). Does anyone has any idea why this works? Many thanks, Emil Re: Why does t.rowid = t.rowid improv …
/forum/t/125558/2/ - 12416 - 2008-09-29 12:29:17 CDT -   [ Highlight ]

Procedure Creation : Hanging in Parse phase (merged) Open in New Window- Rank: 527
… bidb/udump/bidb_ora_23771.trc Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /backup/oracle/bidbtier System name: Linux Node name: punasapps2.india.ziic.net Rel …
/forum/t/143126/2/ - 51040 - 2009-04-03 11:55:40 CDT -   [ Highlight ]

How to remove blank line shown in output Open in New Window- Rank: 518
… I have set HEADING off. SQL> select table_name from user_tables where table_name like 'TABLE%'; TABLE1 TABLE10 TABLE11 TABLE12 TABLE13 TABLE14 TABLE15 TABLE16 TABLE17 TABLE18 TABLE19 TABLE2 TABLE20 TABLE21 TABLE22 TABLE23 TABLE24 …
/forum/t/138180/2/ - 1441 - 2009-01-02 12:18:34 CST -   [ Highlight ]

Removing multiple tables in one go [merged] Open in New Window- Rank: 507
Removing multiple tables in one go [merged] Hello friends, I have to remove all the tables from one schema. But there are lots of tables available in that schema. Is there any way, so that I can remove those tables by using single command? regards, …
/forum/t/138188/2/ - 6523 - 2008-12-28 21:48:43 CST -   [ Highlight ]

tryky procedure Open in New Window- Rank: 498
… , pio_sta In Out Varchar2) AS tab_scrawbcrgs ty_scrawbcrgs ; lv_prevcarrierid NUMBER(4) :=0; tab_arlscrawbcrgs ty_scrawbcrgs ; tab_aplbascoll ty_aplbascoll := ty_aplbascoll(); tab_aplbas tariff_pkg.ty_aplbascoll; GEN CONSTANT VAR …
/forum/t/64795/2/ - 14859 - 2006-06-14 05:15:49 CDT -   [ Highlight ]

How to retrieve and remove the duplicates? Help! Open in New Window- Rank: 497
… ication. Thanks in advance. SELECT TABLE_PRELIMPROJECT.CODPRO "Preliminary project °", TO_CHAR(TABLE_PRELIMPROJECT.DATOUV,'DD/MON/YYYY') "Open date", TABLE_APPLICATION.CODDOS "Application Number", TO_CHAR(TABLE_PRELIMPROJECT. FLGDAT,'DD/MON/YYY …
/forum/t/45366/2/ - 24112 - 2005-05-07 09:15:14 CDT -   [ Highlight ]

Re: Excel report not formatting correctly in SQL*Plus (multi-merge) Open in New Window- Rank: 493
… ctual column width in excel. All the database columns are in separate cells. I am getting that. How you maintain actual column width in excel when you open the csv file. when i open the excel it is showing default column width. it is not showing acta …
/forum/t/81429/2/ - 58840 - 2009-09-18 20:52:58 CDT -   [ Highlight ]