Latest Answer : Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info. ...
Latest Answer : Dear friend : oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using .nextvalfor eg:let us say we have the following table:sample:x ...
(i)a table is classfied as a parent table and you want to drop and recreat it .how would you do this without affecting the children tables?(II)you want to group the following set of selected returns ,what can you grioup on?max(sum_of_cost),min(sum_of_cost),count(item_no),item_no(iii)"to delete duplicate records from table leaving on set of records"
means i have 150 tables in one system, i want to copy those tables into another system.
Latest Answer : using import/export ...
I will be getting this duration from the dual table. Provide query for this.Like for example, if suppose I am going to get value from the month of 01-Jan-2006 to 31-Apr-2007 then My result should be only
Latest Answer : SELECT TO_CHAR(ADD_MONTHS('01-jan-2007', ROWNUM-1), 'MON')FROM dualWHERE ADD_MONTHS('01-jan-2007',ROWNUM-1) < '30-apr-2007' CONNECT BY LEVEL
I developed like below.Any experts query ....please send.selecttable_name,constraint_namefrom user_cons_columns where column_name=(select a.COLUMN_NAME from user_cons_columns a,user_constraints bwhere
Latest Answer : SELECT uc.CONSTRAINT_NAME, ut.TABLE_NAME, ucc.COLUMN_NAMEFROM USER_CONS_COLUMNS ucc, USER_CONSTRAINTS uc , USER_TABLES utWHERE uc.table_name = ut.TABLE_NAME AND uc.CONSTRAINT_NAME =ucc.CONSTRAINT_NAME ...
How to import tables from MS-Access to Oracle?
Latest Answer : This might help someone if need to get table into Oracle from MS Access table.Option-1 - Use MS Access (2003) Export 1. Oracle Client and Oracle ODBC driver should be installed on your PC.2. In ODBC Admin, create System DSN or File DSN for your Oracle ...
What are the virtual tables used in Oracle?
