what is meant by magic query
No Answer is Posted For this Question
Be the First to Post Answer
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
What are the execution control statements in oracle?
How to add a new column to an existing table with a default value?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
what is a cartition product?
How to open a cursor variable?
How to define a variable to match a table column data type?
What do you mean by group by clause?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Can the query output be sorted by multiple columns in oracle?