SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
ESS,
1 4549WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
ESS,
1777Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
3 5759I 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
3774
What is the process of normalization?
How to create a new table in a given schema?
What is the difference between internal & external schema?
What things to be taken in consideration for lookup fields?
What is a database lookup?
What is trigger types of trigger?
Is resultset an interface?
What is model database? : sql server architect
Name the different triggers associated with oracle forms having a master-detail relationship.
How to override dml statements with triggers?
Does union all remove duplicates?
What is data modeling and Reterminal integrity?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What can I use instead of microsoft access?
What is implicit cursor in pl sql?