How to change the order of columns in Oracle SQL Plus ?
No Answer is Posted For this Question
Be the First to Post Answer
what are integrity rules?
What types of commands can be executed in sql*plus?
How do we tune the code?
What is a cursor for loop ?
what is SCALAR Queries?
Is left join inner or outer by default?
Is subquery faster than join?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
What are different functions in sql?
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)