How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
2 5402SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
1 2294What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
1077how 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 2258Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
140Post New Infosys Oracle General Interview Questions
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
sir what is the depreciation and how to calculate depreciation as per company books, i need as per IT ACT, AND Companies Act give me clarification with example
Explain the importance of cloud computing in IT?
What are the requirements of a good fuel?
What is transister define the transister ammiter ,base, colector.
What are CAPIs ?
Hi , Does anyone have advanced sas certification latest dumps(a00-212). please mail me to sunnyspells9@gmail.com Thank you sunny
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
who is first vice primeminister who is first prime minister when did first world war arise when did second world war arise
How would you finalize the number of resources/testers needed for the testing in the estimation ?
SAP SD. What are the Condition Conversion and Customer/Material conversion in the Organization Structure and should define and assign? Please nevigate and explain with example.
Customs Duty is fixed or Non Fixed
I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...
alternator make voltage 120 degree. as we change degree ex. 100 and 160 or other degree then voltage make. yes or no and why
How to findout raw or ups power? its not indicated in socket,
- Software (1)
- C (95)
- STL (3)
- OOPS (27)
- C++ General (22)
- MFC (3)
- VC++ AllOther (2)
- Delphi (4)
- Python (2)
- PHP (10)
- Programming Languages AllOther (12)
- ASP (2)
- JavaScript (8)
- VB Script (2)
- JSP (1)
- Shell Script (2)
- AJAX (1)
- SNMP (1)
- SS7 (1)
- Networking Administration (9)
- Networking Security (2)
- Networking AllOther (3)
- Visual Basic (11)
- C Sharp (6)
- ASP.NET (33)
- VB.NET (7)
- ADO.NET (6)
- IIS (3)
- Dot Net Framework (6)
- Dot Net General (5)
- Dot Net AllOther (3)
- SharePoint (1)
- Microsoft Related AllOther (1) Oracle General (14)
- OCI (1)
- Database Management (3)
- Forms Reports (1)
- Oracle AllOther (3)
- SQL Server (19)
- MySQL (3)
- DB Architecture (1)
- DB Administration (1)
- DB Development (1)
- SQL PLSQL (19)
- Databases AllOther (4)
- SDK (1)
- Windows General (1)
- Windows AllOther (5)
- Linux Commands (2)
- Linux IPC (1)
- Linux Socket Programming (1)
- Linux System Calls (1)
- Unix Commands (27)
- Unix IPC (2)
- Unix General (1)
- Unix AllOther (3)
- Solaris Commands (2)
- Solaris General (1)
- Solaris AllOther (2)
- RTOS AllOther (1)
- Operating Systems General Concepts (7)
- Data Structures (5)
- Operating Systems AllOther (1)
- WinRunner (5)
- Load Runner (6)
- QTP (44)
- Test Director (3)
- Rational TestSuite (1)
- Silk Test (1)
- Selenium (1)
- Automation Testing AllOther (3)
- Manual Testing (93)
- QA Concepts (11)
- Mobile Testing (2)
- Test Cases (10)
- Test Documents Reporting (2)
- Testing AllOther (11)
- Servers AllOther (1)
- COBOL (9)
- JCL (10)
- CICS (1)
- DB2 (9)
- Assembler (1)
- VSAM (5)
- IBM MainFrame AllOther (1)
- DB400 (1)
- COOLPLEX (1)
- Core Java (54)
- Advanced Java (6)
- Swing (1)
- EJB (2)
- Servlets (5)
- Struts (7)
- JDBC (5)
- JMS (1)
- J2EE (3)
- Weblogic (3)
- Websphere (1)
- Java J2EE AllOther (2)
- Java Related AllOther (2)
- HTML DHTML (1)
- Teradata (7)
- Business Objects (14)
- Cognos (10)
- Informatica (14)
- Crystal Enterprise Suite (1)
- Ab Initio (2)
- Data Stage (8)
- SAS (2)
- Micro Strategy (3)
- ETL (7)
- Data Warehouse General (1)
- HR Questions (16)
- Design Patterns (6)
- UML (3)
- OOAD (2)
- Project Planning (9)
- Technical Writer (1)
- Software Design AllOther (1)
- GDB (1)
- Debugging AllOther (3)
- Telecom Routers Switches (1)
- VoIP IP Telephony (1)
- BlueTooth (1)
- Telecom General (2)
- SAP Basis (19)
- SAP ABAP (122)
- SAPScript (1)
- SAP SD (29)
- SAP MM (11)
- SAP QM (1)
- SAP PP (1)
- SAP PS (1)
- SAP FI CO (48)
- SAP HR (6)
- SAP CRM (52)
- SAP Business Warehouse (6)
- SAP Security (8)
- SAP B1 (1)
- SAP Business Objects BO BOBJ (2)
- PeopleSoft Financials (4)
- PeopleSoft Tools (1)
- Oracle Apps Technical (9)
- Oracle Apps Financial (7)
- Oracle Apps SCM (2)
- Oracle Install Base (1)
- ERP CRM AllOther (1)
- 86 Family (2)
- VLSI (3)
- Client Server Architecture (1)
- Client Server General (2)
- AI General (2)
- AI AllOther (1)
- TIBCO (1)
- JCAPS (1)
- Image Processing Algorithms (2)
- Micro Biology (1)
- Bio Informatics (2)
- Botany (1)
- General Physics (2)
- Geo Physics (1)
- Organic Chemistry (1)
- Inorganic Chemistry (2)
- General Chemistry (1)
- Mathematics (1)
- General Science (2)
- Sciences AllOther (1)
- Civil Engineering (13)
- Mechanical Engineering (14)
- Electrical Engineering (40)
- Electronics Communications (61)
- Instrumentation (3)
- Automobile Engineering (1)
- Engineering AllOther (24)
- Business Administration (7)
- Marketing Sales (10)
- Banking Finance (24)
- Human Resources (20)
- Infrastructure Management (1)
- Non Technical (3)
- Business Management AllOther (4)
- Audit (5)
- CompanyAffairs CS (3)
- Taxation (14)
- Accounting General (35)
- Accounting AllOther (37)
- Call Centre AllOther (108)
- Designing (1)
- UPSC Political Science (1)
- UPSC History (1)
- UPSC General Studies (3)
- SSC Political Science (3)
- SSC General Studies (1)
- SSC AllOther (1)
- RRB (2)
- CDS (3)
- NDA (3)
- BSRB Clerical (3)
- Group I (4)
- Group II History (2)
- Group II AllOther (1)
- Group II Political Science (1)
- APPSC AllOther (8)
- General Knowledge_Current Affairs (42)
- Government AllOther (6)
- Law AllOther (3)
- Chefs (1)
- Tourism Hotel AllOther (1)
- Teaching (1)
- Funny Interview Questions (8)
- Everything Else AllOther (13)
- English (18)
- General Aptitude (118)
- Puzzles (49)
- Placement Papers (58)
- CCNA (16)
- Microsoft Certifications (3)
- Sun Certifications (3)
- Oracle Certifications (3)
- ISTQB Certification (1)
- Certifications AllOther (1)
- H1B Visa (5)
- USA Student Visa F1 Visa (3)
- L1 Visa (9)
- USA Business Visa B1 Visa (4)
- USA Dependent Visa H4 Visa (3)
- UK Visa (3)
- C Code (12)
- C++ Code (4)
- MFC Code (1)
- J2SE Code (2)
- ASP.NET Code (1)
- C Sharp Code (3)
- Visual Basic Code (1)
- JavaScript Code (4)
- VB Script Code (1)
- Scripts_Markup Code AllOther (1)
- GATE (5)
- IIT JEE (1)
- CAT (2)
- ICET (5)
- C C++ Errors (1)
- DotNet Errors (1)
- SQLServer Errors (1)
- Scripts Errors (1)
