GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  PL/SQL
Go To First  |  Previous Question  |  Next Question 
 PL/SQL  |  Question 78 of 157    Print  
Hi,

Can somebody please answer couple of my questions ASAP?

1) How do you call a trigger on a table?

2) What is the maximum number of data strings that can be returned through DBMS_OUTPUT?

Much thanks!!

  
Total Answers and Comments: 2 Last Update: February 07, 2007     Asked by: Lisa 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
February 07, 2007 06:36:01   #1  
gchandra_sekar Member Since: February 2007   Contribution: 1    

RE: Hi,Can somebody please answer couple o...
Hi!) Trigger cannot be called as it automatically gets activated once u touch the table.2) Prior 10g user SQL> set serveroutput on size 1000000 or if it is 10gORA10GR2> set serveroutput on size unlimited
 
Is this answer useful? Yes | No
February 07, 2007 20:50:05   #2  
madhuk17 Member Since: February 2007   Contribution: 15    

RE: Hi,Can somebody please answer couple o...
Hi,I think trigger is not called.The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place.I think maximum number of data strings that can be returned through DBMS_OUTPUT is 255 bytes.
 
Is this answer useful? Yes | No

 Related Questions

Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present in a table, it's there in some file.For eg. "Data" is the file, it contains information: 2489078905,2345678909 and so on...table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.got it, Right!Let me know if u have any questions.thanks.dev
Read Answers (2) | Asked by : dev

Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer

Hi,Can somebody please answer couple of my questions ASAP?1) How do you call a trigger on a table?2) What is the maximum number of data strings that can be returned through DBMS_OUTPUT?Much thanks!!
Read Answers (2) | Asked by : Lisa


 Sponsored Links

 
Related Articles

Is Career Change The Answer To Your Success?

Personal careers are always a critical aspect for anyone. A career path is not easy to abide by, considering that there will always be external factors such as that of new occupations and job openings of another field that people would want to consider.  There are varying factors that can
 

HR Interview - Most Popular HR Interview Questions With Generic Answer Formats

Most Popular HR Interview Questions With Generic Answer Formats While it is impossible to know exactly what you will be asked during a job interview there are a number of generic questions that most companies will ask you mosgoogle In this article I will present you with some questions that are comm
 

HR Interview - How To Deal With Tricky Interview Questions

How To Deal With Tricky Interview Questions During your HR interview you will be presented with a number of questions from the interviewer The way you answer these questions will play a role in whether or not you re hired While some of these questions have obvious answers others will be tricky and t
 

Questions You Should Be Prepared For During A Job Interview

Questions You Should Be Prepared For During A Job Interview While the way you answer questions during a job interview will only play a small role in whether or not you are hired it is important to pay attention to them Going to a job interview can be stressful especially if it is a highly competitiv
 

ASP.NET Interview Questions

Microsoft ASP NET Interview Questions This article provides Microsoft Interview Questions covering Microsoft ASP NET questions For more Interview Questions Answers related to Microsoft click on links provided at the end of each question set mosgoogle Microsoft ASP NET Interview Questions 1 What is R
 

C# Interview Questions

Microsoft C Interview Questions This article provides Microsoft Interview Questions covering Microsoft C questions For more Interview Questions Answers related to Microsoft click on links provided at the end of each question set mosgoogle Microsoft C Interview Questions 1 What is indexer Where it i
 

C Interview Questions

C Interview Questions This article provides C Interview Questions For more Interview Questions Answers related to C click on links provided at the end of each question set mosgoogle C Interview Questions 1 A switch statement cannot includea constants as arguments b constant expression as argumentsc
 

DB2 Interview Questions

DB2 Interview Questions This article provides Mainframe Interview Questions covering db2 questions For more Interview Questions Answers related to Mainframe click on links provided at the end of each question set mosgoogle 1 Loading of DB2 Unload with packed Decimal’ data to Oracle envi
 

Siebel Interview Questions

Siebel Interview Questions This article provides Siebel Interview Questions For more Interview Questions Answers related to Siebel click on links provided at the end of each question set mosgoogle Siebel Interview Questions 1 What is foreign key table in Siebel 2 Why do you need Primary in MVG 3 Whe
 

JCL Interview Questions

JCL Interview Questions This article provides Mainframe Interview Questions covering JCL questions For more Interview Questions Answers related to Mainframe click on links provided at the end of each question set mosgoogle JCL Interview Questions 1 What is the advatage of coding RECFM F over RECFM F
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape