select column from tablename
If you are going to use the date column in the WHERE clause of you select, THEN Indexing on that date column will enhance the performance Hope this helps
List of Values (LOV) is a small pop up window that allows user to select a single or a multiple column in an oracle form. Lov can be created based on SELECT query, non-select query or static values
Click on the letter at the top of the column; that will select the entire column.
many a time you may require to add a row of data or a coloumn of data which you forgot to enter earlier .excel proveides you the facility to insert rows or columns onto the sxisting worksheet very easily .it is that inserting a row of data will shift the rest of the rows down and cause the ladt row of the worksheet ,the rest of the columns shift right ,if there is any data in the last row or column of the worksheet that will be lost .
select * from v$version where banner like 'oracle%';
select statement in oracle which is used to calculate average,min,max etc is an expression
sql>select * from user_tab_privs;
Clicking on the header of the row or column will select it. So for example, to select row 3, click on the 3 at the start of it or to select column R, click on the R at the top of it. Pressing Ctrl and the spacebar will select the current column. Shift and spacebar will select the current row.
Shift + cntrl + c
Just click the column header (where the column letter is).
Place the cursor in the row or column to be selected. Press the shift key and the spacebar to select a row. Press the Ctrl key and the spacebar to select a column. Using the mouse you can click on the row number or column letter to select the row or column.
Actually there are several different Yes / No Oracle sites available online. Some examples include "The-Oracle-Answers", "Facade" (select "Yes or No" from the menu) or "Yes No Oracle" from VIP Tarot.