Interested to Buy Any Domain ? << Click Here >> for more details...
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 6113write 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 17445dear 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 5190i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
2 5888In 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 8349Is 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 4655A 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 5404Post New Oracle General Questions
How to start instance with a minimal initialization parameter file?
How to see the table columns used in an index?
What is a database schema in oracle?
How to resolve name conflicts between variables and columns?
What to do if the startbd.bat failed to start the xe instance?
Explain an index segment?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to find the duplicate rows count from employees table in oracle?
What are privileges and grants?
Explain the use of parfile option in exp command.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What are the differences between char and nchar in oracle?
Explain oracle data types with examples?
How to write text literals in oracle?
What would you do with an in-doubt distributed transaction?
