What happens to indexes if you drop a table?
No Answer is Posted For this Question
Be the First to Post Answer
Does rowid change in oracle?
How to change user password in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is Read-Only Transaction ?
What are joins, explain all types of joins?
What is ADDM Advisor in Oracle?
How to Remove the 3rd highest salary person record from table?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
how to find find & delete duplicate rows from two different tables?