why should required for Indexed by table in pl/sql3 4779
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
What is the difference between Outer join and Full outer join?5 32811
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...7 8056
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks2 2846
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.1 1625
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?1 2779
can you any body tell me why are go for the rebuild the master database.what is the reason?2 2470
what is package and it uses and how can u call a package977
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
how to insert data into partitioned table partition done by Range partition1 13323
What different of iner joint & outer joint with example4 6818
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
last function used in MS Access to convert sql what function will use in sql
What is the command that can be used to allocate memory in postgreSQL?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Query processing is slow(eg select query)how will u solve that
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
How to start SQL Server in minimal configuration mode?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Why do you want to join software field as you have done your BE in Electronics?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
how to solve cardinality in dbms...many to many ralationships
did u p prepared complex report
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.