What is a private synonym?
- 0 Answers
- 1285 Views
- I also Faced
- E-Mail Answers
What is the usage of merge statement?
How to connect to the server with user account: sys?
How to write a query with a left outer join in oracle?
Can we call a trigger inside a function and function inside a trigger? Give example.
What is SAVE POINT ?
How to load a large xml file?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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 get the no employee in each department including the dept which has 0 employee
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What happens if the update subquery returns multiple rows?
What is the purpose of a cluster?
Oracle General 
