What is AUTH_ID and AUTH_USER in pl/sql ?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
how to write customizations in po
how to handle exceptions in post production
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
What is Lock table in SQL?
How to get maxsal , minsal, ename department wise in single query
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
Whis is not false in primary key?
Call by value and call by reference in procedure and function, with NOCOPY.
If we delete pack Spec what will be the status of pack Body ?
Delete duplicate rows without using rowid.