How to see on what coloumns the indexes have been created?
Latest Answer: SELECT * FROM ALL_INDEXES WHERE TABLE_NAME = 'table_name'-- It will give u all indexes in required table ...
Latest Answer: Dear Shruti,First query the data dictionary view "USER_CONS_COLUMNS" to find the constraint name.Then instead of dropping the constraint just disable it.step1:--> select constraint_name,column_name from user_cons_columns where table_name='TABLE_NAME'n.b: ...
I cant drop the whole column because that is interlinked with my process? I have declared not null on a column, I have to change it
Latest Answer: Dear Sarika,Instead dropping the constraint just disable the constarint.The command is:Alter table table_name disable constraint constraint_name;try it and reply me ...
For e.g. Create table tempOCT as Select....If i run the code in any day of Nov the table name should be tempNOV.
Latest Answer: You can do one this in the code itself that is going to create the table at run time incorporate the logic to get the currect date, take it as string variable and then in the code itself you can write the query Create table as(..)Might help you.Vishal. ...
Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname
Latest Answer: I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know. ...
Latest Answer: select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) - (select count(days) from (selectto_char(to_date('01/01/2008','dd/mm/rrrr')+level,'D') daysfrom dual connect by level ...
How to insert of only system time(hh:mi:ss) into table columnnot in the format of 'dd/mm/yyy hh:mi:ss' only system time not date.
How can we find the number of day's between any two given date's by using the dual table only?
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
