package specification-3 procedures package body-4 procedures how can i write for other procedure in package body2 4555
what is variable in package specification2 3539
i don't want the message as 14 rows updated just it should update what it will do4 5070
how can i read files from a pl/sq l program3 4821
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?27 27210
what is the command for user data type?2 6077
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.14 22913
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
In testing where do we use sql language and how it helps in testing?2 4283
what command is used to create a table by copying the structure of another table including constraints ?6 9739
How to convert ms-excel file to oracle table?2 6145
How do you use collections in procedure to return the resultset?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Describe the Index, Types of index, At what situation we have used? Which one s better than others?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi email@example.com
What is Temp Table and type of temp table?
What is Materialized View? In What Scenario we Use Materialized View?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification
i have some prob lem to tell me about my self in interview first round ...
write a query that returns first characters of each word in Oracel/Sql pl sql
How global cursor can be declare with dynamic trigger ?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10