Explain Connect by Prior ?in a session before accessing next value ?

Explain Connect by Prior ?in a session before accessing next value ?
by

1 Answer

Answer :

Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.
by

Related questions

What is ROWID ?in a session before accessing next value ?

Description : What is ROWID ?in a session before accessing next value ?

Last Answer : ROWID is a pseudo column attached to each row of a table. It is 18 character long, blockno, rownumber are the components of ROWID.

What are the usage of SAVEPOINTS ?value in a session before accessing next value ?

Description : What are the usage of SAVEPOINTS ?value in a session before accessing next value ?

Last Answer : SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Description : How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Last Answer : Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.

What is the fastest way of accessing a row in a table ?

Description : What is the fastest way of accessing a row in a table ?

Last Answer : Using ROWID.CONSTRAINTS

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

The service access points in Session Layer are called ________________ A. Accessing point B. activation point C. Session Service Access Points D. both a and b

Description : The service access points in Session Layer are called ________________ A. Accessing point B. activation point C. Session Service Access Points D. both a and b

Last Answer : C. Session Service Access Points

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

How can you enable a trace for a session?

Description : How can you enable a trace for a session?

Last Answer : Use the DBMS_SESSION.SET_SQL_TRACE or Use ALTER SESSION SET SQL_TRACE = TRUE;

How do you create a new session while open a new form?

Description : How do you create a new session while open a new form?

Last Answer : Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

When creating a user, what permissions must you grant to allow them to connect to the database?

Description : When creating a user, what permissions must you grant to allow them to connect to the database?

Last Answer : Grant the CONNECT to the user.

Can you connect to non - oracle datasource ? How?

Description : Can you connect to non - oracle datasource ? How?

Last Answer : Yes .

How does one connect to an administrative user? (for DBA

Description : How does one connect to an administrative user? (for DBA

Last Answer : If an administrative user belongs to the "dba" group on Unix, or the "ORA_DBA" (ORA_sid_DBA) group on NT, he/she can connect like this: connect / as sysdba No password is required. This ... connections via Net8 are classified as non-secure. Look at this example: connect sys/password as sysdba

Can you connect to a local database without a listener?

Description : Can you connect to a local database without a listener?

Last Answer : Yes, you can.

Name three clients to connect with Oracle, for example, SQL Developer:

Description : Name three clients to connect with Oracle, for example, SQL Developer:

Last Answer : SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL Developer… There are several, but an experienced dba should know at least three clients.

'Zero Hour' in the working of the Indian Parliament means – (1) Hour before the Question Hour (2) The first Hour of the Session (3) Interval between Question Flour and next Agenda (4) When Privilege Motion, is accepted

Description : 'Zero Hour' in the working of the Indian Parliament means – (1) Hour before the Question Hour (2) The first Hour of the Session (3) Interval between Question Flour and next Agenda (4) When Privilege Motion, is accepted

Last Answer : (3) Interval between Question Flour and next Agenda Explanation: Zero Hour in Parliament starts at 12 noon during which members raise matters of importance, especially those that cannot be ... members can raise questions about any aspect of administrative activity. Zero Flour follows Question Hour.

Do you need to instantiate a class before accessing a Shared (static) member? Why or why not?

Description : Do you need to instantiate a class before accessing a Shared (static) member? Why or why not?

Last Answer : Because a Shared (static) member belongs to the type rather than to any instance of the type, you can access the member without first creating an instance of the type.

Karthiga jogs a speed of 18 km/hr at a distance of 27 km. at what speed would she need to jog during the next 4.5 hrs to have an average of 27km/hr for the entire jogging session. a) 40km/hr b) 30 km/hr c) 20 km/hr d) 35 km/hr

Description : Karthiga jogs a speed of 18 km/hr at a distance of 27 km. at what speed would she need to jog during the next 4.5 hrs to have an average of 27km/hr for the entire jogging session. a) 40km/hr b) 30 km/hr c) 20 km/hr d) 35 km/hr

Last Answer : B Let the speed of jagging be x km/hr Total time taken = (27/18 hrs + 4.5 hrs) =(1.5 hrs + 4.5 hrs) =6 hrs Total distance covered = (27+4.5 x) km Therefore (27 +4.5x) / 6= 27 27+4.5x = 162 4.5x = 135 X=135/4.5 =30 So jagging speed is 30 km/hr

At what point of report execution is the before Report trigger fired?

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

Does one need to drop/ truncate objects before importing? (for DBA

Description : Does one need to drop/ truncate objects before importing? (for DBA

Last Answer : Before one import rows into already populated tables, one needs to truncate or drop these tables to get rid of the old data. If not, the new data will be appended to the existing tables. ... to speed up the import process. Indexes can easily be recreated after the data was successfully imported.

Atleast how many set of data must a data model have before a data model can be base on it?

Description : Atleast how many set of data must a data model have before a data model can be base on it?

Last Answer : Four

Does a Before form trigger fire when the parameter form is suppressed?

Description : Does a Before form trigger fire when the parameter form is suppressed?

Last Answer : Yes.

What was RAC previous name before it was called RAC?

Description : What was RAC previous name before it was called RAC?

Last Answer : OPS: Oracle Parallel Server

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

The value recorded in system.last_record variable is of type

Description : The value recorded in system.last_record variable is of type

Last Answer : a. Number b. Boolean c. Character. ? b. Boolean.

maxvalue.sql Select the Nth Highest value from a table?

Description : maxvalue.sql Select the Nth Highest value from a table?

Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level

minvalue.sql Select the Nth lowest value from a table?

Description : minvalue.sql Select the Nth lowest value from a table?

Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level

Display the number value in Words?

Description : Display the number value in Words?

Last Answer : SQL> select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp; the output like, SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP')) --------- ---------------------------------------- 800 ... ---------- 800 Rs. Eight Hundred only. 1600 Rs. One Thousand Six Hundred only. 1250 Rs. One Thousand Two Hundred Fifty only.

VALUE SET LIST TYPES

Description : VALUE SET LIST TYPES

Last Answer :  List of values (10 to 200)  Long list of values (> 200)  Poplist (> 10)

Do you see lot of ads while accessing this site?

Description : Do you see lot of ads while accessing this site?

Last Answer : I stay logged in on both desktop and mobile but if you are not or not a member, you will see ads. It’s some of the revenue.

Why am I getting an "Internal Server Error" when I'm accessing ask-public on my laptop?

Description : Why am I getting an "Internal Server Error" when I'm accessing ask-public on my laptop?

Last Answer : It’s not just you. See every other recent meta question from lately. We are having server problems.

Why am I getting the message "Application has been blocked from accessing Graphics hardware"? (cont.)

Description : Why am I getting the message "Application has been blocked from accessing Graphics hardware"? (cont.)

Last Answer : answer:Is a pop-blocker on? Also, try opening it in a different browser.

What else is a problem for smartphones other than accessing links?

Description : What else is a problem for smartphones other than accessing links?

Last Answer : Typing in the rain.

What are some of the most useless security questions you've been prompted to give the answers to when accessing an online account?

Description : What are some of the most useless security questions you've been prompted to give the answers to when accessing an online account?

Last Answer : answer:Some of the security questions asked by my AT&T account involved some really obscure crap to which I never gave any thought. E.g., what style are your favorite shoes, or what color are your father’s favorite socks?

I have problems accessing folders shared on the network on a Win7 machine from a virtual WinXP machine. What can I do to fix it?

Description : I have problems accessing folders shared on the network on a Win7 machine from a virtual WinXP machine. What can I do to fix it?

Last Answer : My system is run from XP then to a D-link router to a Windows 7 laptop.and I send folders by internet. Not exactly your problem but it works. If those folders are in an earlier Office on the XP you ... at all. I do love my favorite solution for most computer problems I call my son to come over. :-)

How can I tell if someone is accessing my router?

Description : How can I tell if someone is accessing my router?

Last Answer : The router logs will tell you. Why is it unsecured? At least turn MAC address limiting on.

Mac Question: Is someone accessing my computer?

Description : Mac Question: Is someone accessing my computer?

Last Answer : You were on a network and what you saw was the shared access to other computers on that network. You should not have been at risk, unless you have enabled sharing on your own computer. Even ... the box are not so easily accessible for other computers on the same network, unless it is intentional.

What is the difference between http and https when accessing Google Reader?

Description : What is the difference between http and https when accessing Google Reader?

Last Answer : https is encrypted both ways. Portions of a page can be encrypted and not others, but your browser should (or at least can be set up to) warn you if that’s the case.

Laleema Chakradhar wants a broadband connection for accessing her mails and staying informed about the latest -Technology

Description : Laleema Chakradhar wants a broadband connection for accessing her mails and staying informed about the latest -Technology

Last Answer : VSNL, Airtel etc.

How can you block an IP address from accessing your website?

Description : How can you block an IP address from accessing your website?

Last Answer : There is a lot of ways to do this but I prefer to use a security plugin that's called wordfence. Not only you can block an IP Address but you can even block a whole country, just a ... , a tablet address etc. So many options using wordfence. Hope this answers your question. Best Regards, Nesim

How much is a wireless air card for accessing the internet from my laptop?

Description : How much is a wireless air card for accessing the internet from my laptop?

Last Answer : Typically the price for a wireless aircard ranges between twenty and sixty dollars depending upon the range. This is a great feature to have and is really convenient! Good luck!

Communications between Tomcat and the Web browser accessing the ePO console is accomplished using ________ traffic through port __________.?

Description : Communications between Tomcat and the Web browser accessing the ePO console is accomplished using ________ traffic through port __________.?

Last Answer : 8080

What is backup? 1) Adding more components to your network 2) Protecting data by copying it from the original source to a different destination 3) Filtering old data from the new data 4) Accessing data on tape 5) None of these

Description : What is backup? 1) Adding more components to your network 2) Protecting data by copying it from the original source to a different destination 3) Filtering old data from the new data 4) Accessing data on tape 5) None of these

Last Answer : Answer :2

The method of accessing the I/O devices by repeatedly checking the status flags is_________ A. Memory-mapped I/O B. Program-controlled I/O C. I/O mapped D. None of the Above

Description : The method of accessing the I/O devices by repeatedly checking the status flags is_________ A. Memory-mapped I/O B. Program-controlled I/O C. I/O mapped D. None of the Above

Last Answer : B. Program-controlled I/O

A method of multiple accessing where a given RF channel bandwidth is divided inot smaller frequency band. A. CDMA B. ANIK-D C. TDMA D. FDMA

Description : A method of multiple accessing where a given RF channel bandwidth is divided inot smaller frequency band. A. CDMA B. ANIK-D C. TDMA D. FDMA

Last Answer : D. FDMA

A packet filtering firewall can a. deny certain users from accessing a service b. block worms and viruses from entering the network c. disallow some files from being accessed through FTP d. block some hosts from accessing the network

Description : A packet filtering firewall can a. deny certain users from accessing a service b. block worms and viruses from entering the network c. disallow some files from being accessed through FTP d. block some hosts from accessing the network

Last Answer : d. block some hosts from accessing the network

Software that prevents unauthorized persons from accessing certain parts of a program, database or network is: a) Firewall b) Scanner c) Anti - Virus d) None of These

Description : Software that prevents unauthorized persons from accessing certain parts of a program, database or network is: a) Firewall b) Scanner c) Anti - Virus d) None of These

Last Answer : a) Firewall

Firewalls are frequently used to prevent unauthorized internet users from accessing private networks connected to the internet especially ____: a) Intranets b) Extranets c) Both of Above d) None of These

Description : Firewalls are frequently used to prevent unauthorized internet users from accessing private networks connected to the internet especially ____: a) Intranets b) Extranets c) Both of Above d) None of These

Last Answer : a) Intranets

A modem is not needed when accessing the internet through: a) LAN b) Cable c) Wi - Fi d) None of These

Description : A modem is not needed when accessing the internet through: a) LAN b) Cable c) Wi - Fi d) None of These

Last Answer : a) LAN

______ a document means the file is transferred from another computer to your computer a) Uploading b) Really Simple Syndication c) Accessing d) Downloading e) None of these

Description : ______ a document means the file is transferred from another computer to your computer a) Uploading b) Really Simple Syndication c) Accessing d) Downloading e) None of these

Last Answer : b) Really Simple Syndication