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 : Say you are using the seq name temp_seqCREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
VALUES (temp_seq.nextval,'oracle') ...
(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 : Try this script, Example
SELECT child.table_name AS "TABL_NAME_2", 'Is Parent Of' AS "RELATION", parent.table_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?
How to combine two separate table into one?
Latest Answer : By using UNION SET operator we can combine the two seperate tables. ...
How can we know the all tables and views that are given for the specific user(such as USER_VIEWS,USER_OBJECTS etc.)?
Latest Answer : Open dba_objects in that open column name owner, in that mention user name and it will display the list of tables and views of specific users. ...
