Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')
2 6756I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access
4 4796I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.
1762how 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?
1 3465I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
1646two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
2 4042I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
1 3932How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
1 5317
Does mongodb cost money?
Give string types available for column?
What are the levels of architecture?
What are the main sources of data?
What is sql analyzer?
What are the data types in postgresql?
Does a server store data?
What is open client in sybase?
What command do you type to exit the postgresql console application?
What is clob in mysql
explain what is raid and what are different types of raid configurations? : Sql server database administration
List the different types of joins?
does the query needs a hint to access a materialized view?
What happens in oracle commit?
Explain data independence?