What view(s) do you use to associate a users SQLPLUS session
with his o/s process?
No Answer is Posted For this Question
Be the First to Post Answer
Give the Types of modules in a form?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What are the different pseudo commands? Explain in general?
List out the types of joins.
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What are the uses of Rollback Segment ?
How to define and use table alias names in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
does Oracle has only one table space?
What is the difference between translate and replace?
How to delete an existing row from a table in oracle?
Explain a data segment?