Explain mutating table error.
How to copy a table in another table with datas?
using comand prompt how can import table data and table space with example
how to write utl file pkg in SQL
How does pl sql work?
What is input buffer in sql*plus?
What is a left join?
i have some prob lem to tell me about my self in interview first round ...
What are the different types of a subquery?
What are all the different types of indexes?
Write a query to find five highest salaries from EMP table. (there is a column SALARY)
24 Answers Cap Gemini, iNautix,
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
how to saw triggers output in pl/sql database?