how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
2 5051write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
11 13560dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
3 4010i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
2 4735In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
4 6510Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
IBM,
1 3771A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
IBM,
1 4601Post New Oracle General Questions
How many types of database triggers exist?
What is java oracle used for?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to use attributes of the implicit cursor in oracle?
Give syntax for SQL and ORACLE joins.
What is meant by a deadlock situation?
How do we create privileges in oracle?
How to install oracle odbc drivers?
What are the different types of failures that occur in Oracle database?
How can windows applications connect to oracle servers?
How to add a new column to an existing table in oracle?
What happens if variable names collide with table/column names?
How to call a stored function with parameters?
Is primary key indexed by default in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.